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

Two different admin users created for repository are ______ and_______

1 Answers  


what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,


How will you update the row without using update statergy?

10 Answers   CTS,


List the transformation in informatica.

1 Answers   TCS,


we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  


What is meant by a domain?

0 Answers  


delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,


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

1 Answers  


how many session run unix environment what command using ?

1 Answers   HCL,


how to create a sample mapping for dynamic lookup transformation

2 Answers  


Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  


Categories