Hi friends, my question is
I have 100 records in a source flat file. I want to load odd number records into one target table & even number records into another target table.
Using Informatica how can we do this ?
Thanks inadvance.
Hi friends, my question is
I have 100 records in a source flat file. I want to load odd number records into one target table & even number records into another target table.
Using Informatica how can we do this ?
Thanks inadvance.
use a router transformation and groups with even and odd
for even records give a condition id%2=0
odd records id%2>0
this my idea if id is number.Try it if it not works try anther expression on which column based u want to split that records ok
Hi Jagadishwar,
Thanks for your reply.
I used some other condition i.e mod(num,2)=0 for even number in router transformation. Its working.
num is the column created to hold the serial number, and are generated using sequence generator transformation.
According to your answer, can we use rowid in any expressions for flat files?
Thanks & Regards,
G Gopi Krishna.