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
How to Create a folder using pmrep command?
What is meant by incremental aggregation?
can u any challenge your project?
How many ways a relational source definition can be updated and what are they?
What are the types of schemas we have in data warehouse.
Write the advantages of partitioning a session?
What differs when we choose the sorted input for aggregator transformation?
What is repository manager?
What are the differences between oltp and olap?
Explain what are the different versions of informatica?
Why is sorter an active transformation?
How can you define user defied event?
What is a transaction control transformation?
What is an expression transformation?
What is the sequence generator transformation in informatica?