Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Thu, 16 Aug 2007 @ 15:06:14 GMT





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




Subj:   Re: Working with duplicate rows
 
From:   Kamin Shah



If you don't have permanent journaling on, I doubt you can check that out. It is always a good practice to have a column called Last_Update_Timestamp on every table you create. That way you don't have to depend on journaling and also, make sure you default it to current_time.


Kamin Shah
Systems Engineer

ViPS, Inc.





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 09 Nov 2008