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
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Does an informatica transformation support only aggregate expressions?
What is a rank transform?
What is rank transformation?
What are the types of lookup transformation?
How many transformations can be used in mapplets.
Explain informatica architecture - version 8 / 9
What is depict expression change?
How we can create indexes after completing the loan process?
explain about unit testing? in real time?
Separate from a database, an information bazaar, and an information stockroom?
Why do we need informatica?
Design a mapping to load a target table with the following values from the above source?
Could you explain what is enterprise data warehouse?
What are the databases that informatica can connect to windows?