To getTable Counts for multiple tables using DataStage job

[navistar]

Hi Friends,

I have a series of PX jobs that copy data from tables in one schema to another schema with one job for copying each table. All the tables in the source and target schema are exactly the same and these jobs copying each table use a change capture stage to compare the tables and then do the insert/update/delete as necessary. At the end of this job sequence, I am planning to have a job that would compare the row counts of all the source tables to that of the target tables and produce a control file with the comparison of the row counts.

Would any of you be able to let me know the best way to approach this problem?

Thanks!

[ray.wurlod]

Download EtlStats from Kim Duke's website and let it gather the statistics for you.