Page 2 of 2
Posted: Tue Feb 26, 2013 12:19 pm
by chulett
You'll find that basically every DS API function has an equivalent from the command line via dsjob.
@OUTROWNUM can be used in transformer
Posted: Tue Feb 26, 2013 2:23 pm
by sudha03_vpr
@OUTROWNUM can be used in transformer to get the number of records coming out of the link.
Re: @OUTROWNUM can be used in transformer
Posted: Tue Feb 26, 2013 3:11 pm
by ray.wurlod
sudha03_vpr wrote:@OUTROWNUM can be used in transformer to get the number of records coming out of the link.
... per node
Posted: Tue Mar 05, 2013 3:39 am
by 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.