Diff B/W
MAP Parameter,
SESSION Paramater,
DataBase connection session parameters.?
Its possible to Create 3parameters at a time?
If Possible which one will fire FIRST?
Answer Posted / ajalali
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.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What are the modules in Power Center
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the different types of repositories created using informatica?
What is informatica metadata and where is it stored?
Explain the tuning lookup transformation - informatica
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is union transformation in informatica?
Differentiate between router and filter transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the restrictions of union transformation?
What is blocking transformation?
Slowly changing dimensions, types and where will you use them
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How an expression transformation differs from aggregator transformation?