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 |
Can you copy the batches?
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
Explain lookup transformation is active in informatica
What is resilience time?
What is an incremental loading? in which situations we will use incremental loading
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
What is up date strategy and what are the options for update strategy?
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
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
what is the diff b/w union and joiner and lookup?
what is the dashbords?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?