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
Answers were Sorted based on User's Feedback
Take one variable $$var
in exp trans take one variable port and assign set variable($$var,$$var+1)
then take one router transformation with three group
mod($$var,3)=1 to one tgt
mod($$var,3)=2 to next tgt
mod($$var,3)=0 to another tgt
SD-SQ-EXP-ROUTER-TD1 TD2 TD3
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sg
SQ-Exp-Rou-Tg1 TG2 Tg3
Exp transformation: for generating sequence number ( u can use sequence generator setting max value to 3)
o_count = iff(o_count=0 or o_count=4,1,o_count+1)
Router group condition,
O_cout=1, TG1
O_cout=2, TG2
O_cout=3, TG3
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
Answer / ganesh kamble
We can clearly understand that we need a Router transformation to route or filter source data to the three target tables. Now the question is what will be the filter conditions.
First of all we need an Expression Transformation where we have all the source table columns and along with that we have another i/o port say seq_num, which gets sequence numbers for each source row from the port NEXTVAL of a Sequence Generator start value 0 and increment by 1.
Now the filter condition for the three router groups will be:
MOD(SEQ_NUM,3)=1 connected to 1st target table MOD(SEQ_NUM,3)=2 connected to 2nd target table MOD(SEQ_NUM,3)=0 connected to 3rd target table
Is This Answer Correct ? | 1 Yes | 2 No |
Why do we need informatica?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
How informatica process data means how informatica works?
wat are deployement groups in informatica, how it will be used for developers
Why sorter is an active transformation?
What are the differences between oltp and olap?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How you can differentiate between connected lookup and unconnected lookup?
where actually the usage of push down optimization happens...
Which will beter perform IIf or decode?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.