Wednesday, June 8, 2011

Even Records - Odd Records Loading..

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

4 comments:

  1. Informatica Online Training | Informatica Online Training in India Hyderabad | Best Informatica Online Training
    Informatica 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

    ReplyDelete
  2. Thanks for providing the best information it's very useful for INFORMATICA learners.we also provide the bestINFORMATICA Online Training.

    ReplyDelete
  3. Thanks 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..

    ReplyDelete