Explain about the concept of mapping parameters and
variables ?
Answers were Sorted based on User's Feedback
Answer / neena
Mapping parameters represents a constant value that we cant
change during the seesion run.
Mapping variables represents a value that we can change
during the seesion run.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / manju
Mapping parameters s a constant value and mapping variables
will change in the mapping.It is mainly usefull for
incremental load processing
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rekha
MAPPING PARAMETERS :
MAPPING PARAMETERS REPRESENT A CONSTANT VALUE AND DOES NOT
CHANGE DURING THE SESSION
MAPPING REUSABILITY CAN BE ACHEIVED
MAPPING VARIABLE REPRESENTS A VALUE THAT CHANGE THE VALUE
DURING THE EXECUTION FROM INITIAL VALUE TO THE FINAL VALUE
MAPPING VARIABLES USE IN INCREMENTAL LOAD PROCESS
| Is This Answer Correct ? | 3 Yes | 0 No |
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
What is the difference between unicode & ascii mode data movement in informatica?
What differs when we choose the sorted input for aggregator transformation?
Explain in detail about scd type 1 through mapping.
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
Whats there in global repository
What is the difference between a router and a filter transformation?
What is workflow? What are the components of workflow manager?
How identifying bottlenecks in various components of informatica and resolving them?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is the Rankindex in Ranktransformation?
what is $$$$?