Need to access rows added to a hash file and to a table

[clarcombe]

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

[chulett]

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.

[mujeebur]

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.

[ray.wurlod]

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.