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!
To getTable Counts for multiple tables using DataStage job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Download EtlStats from Kim Duke's website and let it gather the statistics for you.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.