DSXchange

After a job sequencer has run, I want to run a job that picks out the number of rows written to a series of hash files and also written to tables.

It is nothing fancy, just a checklist with
Hash Table : xx rows written

I am happy to search in help and on this forum but don't know what I am looking for.

Thanks

Colin

A routine would work quite nicely in that regard, depending on what you need to do with the information. In any case, seach on DSGetLinkInfo for a way to query a completed job for the number of rows that went down any given link.

You can genearte a report with all the links information on the transformer properties "after subroutine" to "JobReport" , which gives total of record counts traversed on each link.

Just look in the job log for the "active stage finishing" event. All the link row counts are there.

Beware, however, that the number of rows written to a hashed file is not necessarily the same as the number of new rows. Hashed files use a destructive overwrite if the key is the same as an existing one.

If you need the number of new/newly-changed rows, then you will need some way to identify those rows, such as a batch/run identifier or a timestamp.