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 |
What is domain and gateway node?
How many ways you create ports?
if we have a delimiters at unwanted places in a flat file how can we over come those.
can v update d records in target using update stargey without generationg primary key ? explain
What do you mean by filter transformation?
What is an aggregator transformation? it is active why cant it be passive explain?
What is query panel?
if soource is having 10 records how will u insert 20 records to target
HOW TO DELETE A RECORD FROM FLAT FILE
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?
How many number of sessions that u can create in a batch?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?