How to load odd values in one target and even values another, if my source is rdbms and for flat files?
If your Source is RDBMS
Design two piplines with different targets as you wish.. order of ports should be same..
In SQ transformation Override the query as...
In first pipeline SQ
-- SELECT * FROM EMP WHERE (ROWID,0) IN (SELECT ROWID,MOD(ROWNUM,2) FROM EMP)
In second pipeline SQ
-- SELECT * FROM EMP WHERE (ROWID,1) IN (SELECT ROWID,MOD(ROWNUM,2) FROM EMP)
If your Source is a Flat file..
Generate Seq Nos using Seq-Tr by deriving new port in Exp-Tr..
Create Router group..create one group.
> Group1 -- mod(seq_no,2) != 0 -- connect to Even records Table
> Default Group -- connect to Odd Records Table...
- Ram
Informatica Online Training | Informatica Online Training in India Hyderabad | Best Informatica Online Training
ReplyDeleteInformatica Online Training I have taken this course from Attain Technologies. Thay covered all the real time scenarios and their training way was very good approach is very much understandable
Contact them on given contact number is +91 9052820000, +1 2092073642, Email:contact@attainonlinetraining.com
Web: http://attainonlinetraining.com/it-informatica-online-training.html
Thanks for providing the best information it's very useful for INFORMATICA learners.we also provide the bestINFORMATICA Online Training.
ReplyDeleteThanks for providing this article regarding Informatica Online Training I have taken this course from 123Trainings. They covered all the real time scenarios and their training way was very good approach..
ReplyDeleteVery nice article. For for latest iformatica interview questions and answers
ReplyDelete