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
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
Explain in detail scd type 2 through mapping.
How does a sorter cache works?
What are the limitations of joiner transformation?
What is union transformation in informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
what are the deliverables?in your project?
What is the commit type if you have a transaction control transformation in the mapping?
In warehouses how many schemas are there?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the performance considerations when working with aggregator transformation?
Different circumstance which drives informatica server to expel records?
What is data movement mode in Informatica and difference between them?
Explain how to import oracle sequence into informatica?