Is there any script which does a count on the dimension table and the source table.?
you know like how many INSERTS, how many UPDATES and how many DELETES in the target table.
Could you please send me some template so that i get an idea on how to get the record couns based on I,U and D, UI , UD etc
Thanks
-Raj
Shelll Script for row count
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Download ETLStats from Kim Duke's website - note, however, that the row counts from DataStage are simply the rows that are sent to the database - not necessarily the same as the number that were successfully inserted/updated/deleted.
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.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Nagraj,
You can incorporate 'dsjob' commands with combination of unix commands in your shell which you use to run your datastage job.
Steps:
Standardize all the link names from where you want to count the no. of records processed.
List all your grep you into a file using -lstages using dsjob command.
Then write a loop to get the information of the stages by 'grep'ing your standardized link names. Use -stageinfo option to get the link count of each stage.
You can incorporate 'dsjob' commands with combination of unix commands in your shell which you use to run your datastage job.
Steps:
Standardize all the link names from where you want to count the no. of records processed.
List all your grep you into a file using -lstages using dsjob command.
Then write a loop to get the information of the stages by 'grep'ing your standardized link names. Use -stageinfo option to get the link count of each stage.
Thanks and Regards!!
dspxlearn
dspxlearn
I want to get the count of my Target table which is a database and it is maintaining history, and i shd make sure the counts are correct both from the source side and as well from target side,
for example
1 Insert is 1 Insert in Target
1 Update is 1 Insert plus 1 Update in target i.e 2.
How do i get this in the script.
for example
1 Insert is 1 Insert in Target
1 Update is 1 Insert plus 1 Update in target i.e 2.
How do i get this in the script.