What is the difference Between Mapping parameter and variable

Answers were Sorted based on User's Feedback



What is the difference Between Mapping parameter and variable..

Answer / siva

In additon to the Abhinav answer, Once value assigned to
mapping parameter, it can not be change as per login in
mapping.

Where as if you define as mapping variable, it can be
initialized, can be changed the value as per logic in
mapping and even it can be held as persistent to use the
same value in running session next time.

I think you understand this..

Is This Answer Correct ?    5 Yes 0 No

What is the difference Between Mapping parameter and variable..

Answer / abhinav

Mapping parameter is an option in Informatica where, at the
mapping level, you can specify the value to be used.

For example, if there is a field called START_DATE, the
value for this date can be specified by either passing it
as a variable at the mapping level or storing the value in
a parameter file, which will be read during the session is
run.

Is This Answer Correct ?    2 Yes 0 No

What is the difference Between Mapping parameter and variable..

Answer / sankar

mapping parameter: maping parameter is a constent value
that can be defin before maping run
A mapping parameter reuse the mapping for various constant
value.

mapping variable:mapping vareable is represent a value that
can be change during the mapping run
that can be stored in reposatry the integartion service
retrive that value frm repositary and incremental value for
next run

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Informatica Interview Questions

State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers  


What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  


I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,


What is critical mapping?

2 Answers  


What do you understand by a term domain?

0 Answers  


What are the differences between oltp and olap?

0 Answers  


How to extract sap data using informatica?

0 Answers  


i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,


What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,


how to connect two or more table with single source qualifier?

4 Answers   IBM,


in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,


Categories