Differentiate between mapping parameter and mapping variable?
Answer / 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 |
What do you mean incremental aggregation?
what are the difference between Informatica 7.1 and 8.1?
What is mapping debugger?
How to load data in informatica ?
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
What is the sequence generator transformation in informatica?
what is data driven?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
why we r using presql&postsql in source qualifier?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
what is surrogate id ?