Archives of the TeradataForum
Message Posted: Sun, 23 Sep 2002 @ 03:20:02 GMT
| Subj: || || Re: Audit Mechanism in Active Data Warehouse |
| From: || || Wayne Moran |
I worked on a UNIX Data Warehouse project where the data came from MVS. We needed to maintain audits on data that was pre-processed on
MVS and through the multiple UNIX steps.
This was accomplished by creating a control table in Teradata on UNIX. MVS processing sent an audit file to UNIX that contained the
process program, number of records in, number of records out and control totals for selected columns. This was loaded into the control
table. Each step in the UNIX process created the same type of control record. We even did validation of control information between steps
to verify no records were lost. In addition an activity table was created and each UNIX process would insert a start record at the
beginning and an end record as the end. This allowed timings to be calculated to identify long running processes.
Wayne N. Moran