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
- 5522 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to configure mapping in informatica?
where to store informatica rejected data? How to extract the informatica rejected data?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Does an informatica transformation support only aggregate expressions?
What is the meaning of up gradation of repository?
What is meant by lookup transformation?
explain abt ur project architecture?
What is an aggregator transformation?
Why filter transformation is an active one?
Explain sessions?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to differentiate between the active and passive transformations?
Explain the code page compatibility?
What's the layout of parameter file (what does a parameter file contain?)?
What is meant by query override?
