|
Your options for recording the audit information of loads can be done in
numerous ways. Your decision will depend upon the granularity that you wish
capture and where you wish to place the information. Your options depend if
you wish to capture row level errors or simply load data. As well you must
consider if you wish to put your data in a flat file or within the database.
Based on your configuration you have told me about in your question, it is
my understanding that you want simply to store the results of the loads.
Since you are using DataStage as your ETL tool, you can simply use an
aggregator stage to create a count of the records that have passed through
to the end of your DataStage job. You can then populate data into a table
that will hold the date of the load, the job name or table loaded and then
the row count. I think that should provide you with the audit results that
you are looking for.
For More Information
|
