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 |
In session log thier should not be a single error how will u do
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
In informatica workflow manager, how many repositories can be created?
Differnce between filter and router?
how to get the first row without using rank t/r?
What do you mean incremental aggregation?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
What is decode in static cache?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
What are the prerequisite tasks to achieve the session partition?