Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 23 Sep 2002 @ 03:20:02 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016