when a job is finished insert information about the job into a statist table datastage

Such load stats are really useful and there are several way to achieve this. The main question is how to get the total record information amd how those are defined. The is a number of rows getting read from the source and a number written into the target – only if you do not have any filtering in your Transformer (and no rejects) those shoule be the same.

You can get this from

  • the link information via DSGetLinkInfo
  • by running a count on your target table
  • or – my recommendation – by using the DSODB

Check out the Section Monitoring job and job runs by using the Operations Console in the Knowledge Center or if you want to create your own table Extracting Monitor data from the operations database

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top