Explain about the concept of mapping parameters and
variables ?

Answers were Sorted based on User's Feedback



Explain about the concept of mapping parameters and variables ?..

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

Explain about the concept of mapping parameters and variables ?..

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

Explain about the concept of mapping parameters and variables ?..

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

Post New Answer

More Informatica Interview Questions

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  


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

0 Answers  


What is status code in informatica?

0 Answers  


any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  


How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,


What is event and what are the tasks related to it?

0 Answers  


If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  


what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,


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

3 Answers   Satyam,


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?

3 Answers   Wipro,


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

1 Answers   HP,


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 ??

1 Answers   IBM,


Categories