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 the surrogate key?
Describe expression transformation?
What are different types of transformations available in informatica?
can we use mapplet as starting n ending object in mapping
What are the connected or unconnected transforamations?
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
Why filter transformation is an active one?
without dynamic lookup how to insert new rows and update existing rows?
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
What is a router transformation?
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project