Interested to Buy Any Domain ? << Click Here >> for more details...
i have a source table and 3 target table.
when session runs first time-1st tgt
second time-2nd tgt
third time-3rd tgt
fourth time-again 1st target. so no
- 4 Answers
- 7243 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / kamleshmishra291
Take a mapping variable of count type $$INCR=1
After SQ take expression and add a variable port
v_INCR_VARIABLE= IIF($$INCR=3,SETVARIABLE($$INCR,0)+1)
Take router and add three groups
Group1-> $$INCR=1
Group2-> $$INCR=2
Group3-> $$INCR=3
Add groups to respective targets.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is index?how it can work in informatica
Where is metadata stored?
Why do we need informatica?
Explain the informatica workflow?
can we override a native sql query within informatica? Where do we do it?
What is the difference between informatica 7.0 and 8.0?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Can you generate sequence numbers without using the sequence generator transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
How many transformations can be used in mapplets.
What will be the approach?
Can you use flat files in Mapplets.
What are the differences between oltp and olap?
