Friday 7 January 2011

Lets say  i have more then have record in source table  and i have 3 destination table A,B,C. I have to insert first 1 to 10 record in A then 11 to 20 in B and 21 to 30 in C.
Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on upto last record.
SOLUTION:
Generate sequence number using informatica, add filter or router transformations and define the conditions accordingly…
Define group condition as follows under router groups….
Group1 = mod(seq_number,30) >= 1 and mod(seq_number,30) <= 10
Group2 = mod(seq_number,30) >= 11 and mod(seq_number,30) <= 20
Group3 = (mod(seq_number,30) >=21 and mod(seq_number,30) <= 29 ) or mod(seq_number,30) = 0
Connect Group1 to A, Group2 to B and Group3 to C
Posted by at
Labels:

1 comment:

  1. preythap4 July 2011 at 07:08

    In this scenario we have to use CYCLE with 30 as end value..
    you missed this.

    ReplyDelete

Subscribe to: Post Comments (Atom)