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 |
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
Can we insert ,update ,delete in target tables with one update strategy tran.?
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
Can any body tell about the (UTC) unit test cases with the examples in informatica.
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the session parameters?
What happens if we dont select data driven option?
How you can differentiate between connected lookup and unconnected lookup?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
what is parameter file?
How to load only the first and last record of a flat file into the target?