Record Count

phanikumar · Post by **phanikumar** » Wed Oct 19, 2011 10:27 pm

I have a scenario where i need to calculate the number of records processed from the input and pass that value to another field.Can some one help me with this logic.

Regards

kumar

ray.wurlod · Post by **ray.wurlod** » Wed Oct 19, 2011 11:37 pm

Are you using WebSphere Transformation Extender or DataStage? This forum is for WebSphere Transformation Extender. But your language suggests that the question is about DataStage.

Once we know which product you're using it will be easier to provide a correct answer without having to guess.

chulett · Post by **chulett** » Thu Oct 20, 2011 7:26 am

... and then I'll move it.

phanikumar · Post by **phanikumar** » Thu Oct 20, 2011 3:47 pm

The question i asked is regarding datastage and sorry to post my query in wrong place.I am new to this DSXchange can you suggest me where to post my datasatge queries.

Regards

Kumar

chulett · Post by **chulett** » Thu Oct 20, 2011 5:09 pm

This forum (that I just moved your post to since you marked the job type as Parallel) is the one to use for questions specific to Parallel jobs. There is also a dedicated Server forum and the General one is where "everything else" goes - client questions, sequence job issues, routine coding, etc etc.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 20, 2011 6:07 pm

Run the rows into an Aggregator to count them. The count will be available downstream of the Aggregator stage once all rows are in.

Note that the records on each node are counted separately. So, on a two node configuration, you will get two row counts.

If we understood a little more about your requirement we may be able to come up with a better answer.