DSXchange

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

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.

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.

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.

Use an aggregator

battaliou wrote:Use an aggregator

As mentioned by Craig.