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...