I want to load 1,3,5 in one target and 2,4,6 in 2nd target

[Geek_Guest]

Question asked by Visitor Sri

I have 1 flat file with 1 to 20 records, I want to load 1,3,5...9 in one target and 2,4,6.....10 in 2nd target? How can we achieve this? Thanks in advance

[cme_prak]

Hi guest, using mod function mod(portname,2)=0 - even rows mod(portname,2)=1 - odd rows thx prakash

[salhun86]

I have source as flat file. how can I store the header and trailer into one target and data into another target. target1(header+ trailer) target2

Similar Threads:
Sum of Fields in the Trailer of the Record
header setting
New Header File
I want to load 1,3,5 in one target and 2,4,6 in 2nd target
Advantages of Header files