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 Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020