Page 1 of 1

reading the records from thesored dataset using transformer

Posted: Tue Nov 16, 2004 10:10 pm
by ravikiran2712
iam unable to get the logic in the transfomer stage for retrieving the first 200 records of the sorted data on two fields say store and date.i need to direct only first 200 records for a particular store on a particular date.
thanx in advance and

Posted: Wed Nov 17, 2004 7:43 am
by T42
One suggestion:

Run a before job routine that does a "head -200 #inpufile# > #outputfile#"

Read the output file in the main stream.