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?
- 6 Answers
- 16481 Views
- Accenture, HCL, I also Faced
- E-Mail Answers
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 is the function of union transformation?
How to do the error handling of if ur source is flatfiles?
How to go to the older version for a mapping?
What is meant by query override?
What are different types of transformations available in informatica?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How do you use reject loader.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain what are the different types of transformation available in informatica.
What is a filter transformation?
How can repository reports be accessed without sql or other transformations?
What is the difference between a connected look up and unconnected lookup?
What is a joiner transformation and why it is an active one?
What are the types of schemas we have in data warehouse.
What are the different types of transformation available in informatica.
