row count

suresh_dsx · Post by **suresh_dsx** » Fri Oct 13, 2006 4:51 am

Hi guys,
i need to find a row count when i insert or update the records.
my job is like this
oracle stage--> tranformer-->seq file1
|
seq file2
Whenever i run the job need to find the no of records(row count) ,count those records and place in the seq file2.can any one give the solution for this

Kirtikumar · Post by **Kirtikumar** » Fri Oct 13, 2006 5:01 am

Have you searched the form before posting this?

If not try it. I guess in so many posts, capturing the row count has been discussed.

kumar_s · Post by **kumar_s** » Fri Oct 13, 2006 5:12 am

If you want to calculate the ouput record to seq file1 or seq file2, use @OUTROWNUM. If you want to get the count on total record that extracted by oracle stage, use @INROWNUM.

chulett · Post by **chulett** » Fri Oct 13, 2006 7:18 am

Another option is to use DSGetLinkInfo, either 'after job' or downstream in a Sequence job. Or another link in the current job with the same constraint as the one to seq file2, running into an Aggregator.

battaliou · Post by **battaliou** » Fri Oct 13, 2006 7:25 am

Use an aggregator

kumar_s · Post by **kumar_s** » Fri Oct 13, 2006 7:26 am

battaliou wrote:Use an aggregator

As mentioned by Craig.