Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 01 Dec 2004 @ 22:37:22 GMT


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


Subj:   Re: Statistics Problems
 
From:   Jim Downey

Clay,

We have a metadata table that we allow users to make changes to. This table has a Before update trigger that writes a copy of the old data to a backup table before it allows the update.

This is different than what you are doing because you are changing the data 'live' but it does provide you with an audit trail. It assumes that you always want to show the updated data but it does eliminate the join problem.


Jim



     
  <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: 15 Jun 2023