Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 17 Aug 2007 @ 15:24:52 GMT

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

Subj:   Re: Update vs Delete/Insert
From:   Kamin Shah

Here is a suggestion. I am assuming you use the effective/expiring dates for versioning so that you can go back to the previous version of the record. The best thing to do is move the 'older versions' to a new table and add a Version Start Timestamp to the PK. Keep the PI the same as the current table. Add a version End Timestamp as an attribute.

If you do this, you only need to move the expired record into the Version Table and insert the new row into the current table. I hope that makes sense.

Let me know!!

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