Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 28 Aug 2003 @ 09:15:30 GMT


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


Subj:   Re: How can I tell when the last time a table was modified?
 
From:   Street, John

Normal processes are to have the ETL/application layer do this either via an update/load timestamp/date column in the table or an Audit control table that is maintained by the system.

Other than that if you have access logging or query logging enabled on the system look for an entry that is an update / insert / delete against the table you are wanting to track


Cheers

John



     
  <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