Differentiate between mapping parameter and mapping variable?
Answer Posted / ysindhureddy77@gmail.com
A mapping parameter is a user definable constant that takes up a value before running a session. It can be used in SQ expressions, Expression transformation etc.
A mapping variable is also defined similar to the parameter except that the value of the variable is subjected to change. It picks up the value in the following order.
From the Session parameter file
As stored in the repository object in the previous run
As defined in the initial values in the designer
Data type Default values
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the status code in stored procedure transformation?
what is size of u r database?
How to call shell scripts from informatica?
How might one distinguish in the case of mapping is right or not without associating session?
How you can differentiate between connected lookup and unconnected lookup?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Explain lookup transformation in informatica
How can you generate reports in informatica?
What is Session and Batches?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the function of aggregator transformation?
What is source qualifier transformation in informatica?
What is complex mapping?
What is domain and gateway node?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?