ETL and Data Integration tools - Modern ETL software for everyone

Hi everybody,

Design a transformation to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining records into table C?

I have one source which contain 50 records, my need is the first record goes to A target, the last records goes to B target and remaining records goes to C target.

Can anybody tell me how can I get that?

Thank in advance.
Regards,
Steve

Steve

Several ways of doing it.

If your file is always 50 records you can use record number and split the flow of the data based on the record number using validators.

If the number of records is always different you can create 3 transformations for every part

Peter