What are the mapping paramaters and mapping variables?



What are the mapping paramaters and mapping variables?..

Answer / swetha

Maping parameter represents a constant value that yoU can
define before running a session. A mapping parameter retains
the same value throughout the entire session. When you use
the maping parameter , yoU declare and use the parameter in
a maping or maplet. Then define the value of parameter in a
parameter file for the session. Unlike a mapping parameter,
a maping variable represents a value that can change
throughout the session. The informatica server saves the
value of maping variable to the repository at the end of
session run and uses that value next time yoU run the session.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Informatica Interview Questions

Can you copy the batches?

3 Answers  


suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,


Explain lookup transformation is active in informatica

0 Answers   Informatica,


What is resilience time?

0 Answers  


What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,






My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers   TCS,


What is up date strategy and what are the options for update strategy?

2 Answers  


I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,


Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,


what is the diff b/w union and joiner and lookup?

4 Answers  


what is the dashbords?

1 Answers   IBM,


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

1 Answers  


Categories