Generate report on data movement from source to target
Posted: Mon Jul 27, 2009 8:04 am
Hi,
My requirement is to generate a report that gives the following details for each job that runs on the server.
Number of rows read from source - a
Number of rows inserted into target - b
Number of rows rejected - c
So in any case a = b+c
This kind of reconciliation is a part of the process in our project.
If this report is available in graphical format, then that would be appreciated.
I have tried the options in dsjobs command,DSJobReport in after job sub-routine and the metadata workbench.
But the end result is expected to be something like the DS Job Monitor which shows the data flow through the various stages in the job.
Please advice me on how to proceed.
Thanks,
Murali
My requirement is to generate a report that gives the following details for each job that runs on the server.
Number of rows read from source - a
Number of rows inserted into target - b
Number of rows rejected - c
So in any case a = b+c
This kind of reconciliation is a part of the process in our project.
If this report is available in graphical format, then that would be appreciated.
I have tried the options in dsjobs command,DSJobReport in after job sub-routine and the metadata workbench.
But the end result is expected to be something like the DS Job Monitor which shows the data flow through the various stages in the job.
Please advice me on how to proceed.
Thanks,
Murali