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
| 
