I HAVE 10 records in source. I want to store i record in
target 1, second record in target 2, third record in target
3, 4 th record again in target 11, 5th again in target 2,
6th again in target3 etc.... how it is possible?
- 5 Answers
- 10247 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / manthiramoorthy. g
S-SQ-EXP-SEQ-RTR-Tgt1,Tgt2,Tgt3
In Router: (Group Condition)
MOD(nextval,3)=0 Connect To Tgt1
MOD(nextval,3)=1 Connect To Tgt2
MOD(nextval,3)=2 Connect To Tgt3
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What is a passive transformation?
permutations of mapplet
What is difference between a gateway node and worker node?
Enlist the tasks for which source qualifier transformation is used.
How do you load unique records into one target table and duplicate records into a different target table?
How to load the data from people soft hrm to people soft erm using informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is union transformation in informatica?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How to extract sap data using informatica?
If informatica has its scheduler why using third party scheduler?
write a query to retrieve the latest records from the table sorted by version(scd)
Define pmcmd command?
what is size of u r database?
Define enterprise data warehousing?
