How to get rowcount from transfomer

[Selva_dwh]

I am reading from seq file and have to write it in to 4 tables
Headers table, Details table, Tailers table and T_ETL_COUNT.

I have used 2 transformer in parallel job.
for eg., seq file have 10 rows for detail ,which I am able to read that and write it in details table.


But In run time :
How to find out how many rows was interest ( row count ),
[in DSLink86( details table) ],
and that row count number how to interest in T_ETL_COUNT table, in the col for TOTAL_E.

I try to use @outrownum , @inrownum in the stage var and derivation, but the result was like
1
2
.
.
.
10
for each rows,but I am looking total count and that result ( int )should be getting updated

Pls advice

[Sreenivasulu]

Use Datastage API - DSLinkRowCount (typo..)

Regards
Sreeni

[chulett]

Send a link with a single not null field to an Aggregator and tell it to Count them, then send that output to your table.

[Selva_dwh]

thanks used Aggregator stage and able to count the row and write .