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
What is a passive transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
scenario where i can use only concurrent execution of workflow.
Is there any way to read the ms excel datas directly into informatica?
What is dynamic cache?
Explain the features of connected and unconnected lookup.
What is event and what are the tasks related to it?
What are the measure objects?
How can you increase the performance in joiner transformation?
What is a router transformation?
Repository user profiles
How to load the data from people soft hrm to people soft erm using informatica?
Please let me know how to make Data masking in informatica..
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?