How to capture no of rows processed on link in parallel job

[chulett]

You'll find that basically every DS API function has an equivalent from the command line via dsjob.

[sudha03_vpr]

@OUTROWNUM can be used in transformer to get the number of records coming out of the link.

[ray.wurlod]

@OUTROWNUM can be used in transformer to get the number of records coming out of the link.

... per node

[prasannakumarkk]

"I have to insert the no of rows each DS job Inserts/update/Deletes to the target tables to another table which keeps track of all the DS job info "


If you want to get the number of records processed, the easiest way is to ask the DBMS itself. What is the underlying database. What stage is used to load the records? Try using the pseudocolumns of the database in the after sql to get this counts. There are chances where records pass through the input link of database stages but rejected by the stage. it is not reliable to get the link count.