What is difference between mapping Parameter, SESSION Parameter, Database connection session parameters? It’s possible to create 3parameters at a time? If Possible which one will fire FIRST?

                                                                                                                                                                      

Scenario:

What is difference between mapping Parameter, SESSION Parameter, Database connection session parameters? It’s possible to create 3parameters at a time? If Possible which one will fire FIRST?

Solution:

We can pass all these three types of parameters by using Perameterfile.we can declare all in one parameter file.

A mapping parameter is set at the mapping level for values that do not change from session to session for example tax rates.

Session parameter is set at the session level for values that can change from sesion to session, such as database connections for DEV, QA and PRD environments.

The database connection session parameters can be created for all input fields to connection objects. For example, username, password, etc.

It is possible to have multiple parameters at a time?

The order of execution is wf/s/m.