number of records in source

mohanraj · Post by **mohanraj** » Thu Jun 29, 2006 11:48 pm

hi to all

can anyone tell me how can i count number of records in source(flat file)

Thanks in advance

cheers.....
raju

loveojha2 · Post by **loveojha2** » Fri Jun 30, 2006 12:03 am

Pass source data through a transformer, pass one column from source link, and pass one more column within the transformer (mark it as key) to the output link from the transformer.
Provide derivation as @OUTROWNUM for this column, pass this link to aggregator stage and use count function within the output link of the aggregator stage. This will give you the count of the source rows.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 30, 2006 1:51 am

The @INROWNUM system variable gives you this count as each row is processed. Therefore in the last row it has the total number of rows in the source file.

Pass this through an Aggregator stage with either Last or Max as the aggregation function (Last is more efficient) to get just that number output.

Or you can pass any non null column through an Aggregator with the Count function.