Explain about the concept of mapping parameters and
variables ?
- 3 Answers
- 12514 Views
- HCL, TCS, I also Faced
- E-Mail Answers
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 |
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is status code in informatica?
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
What is event and what are the tasks related to it?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
what is the hint? how to use it to reduce the query processing in program?
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
Teradata 
