Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 11 Apr 2009 @ 22:09:10 GMT

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

Subj:   Re: Identity function sequence number
From:   Victor Sokovin

  I have defined all my tables, with a surrogate key as a NUPI that is created with the Identity function (by default).  

  My question is does the numbering sequence start over after a table is restore using Arcmain?  

Not always, as we can deduct from the following warning in the DBA manual:

"Note: Numbering integrity for identity columns cannot be ensured if restores of tables with identity columns do not involve all AMPs."

Identity columns are not really reliable as far as replication, archiving and restoration are concerned. Also, your design implies that you will never benefit from your NUPIs in any joins or lookups but this is just a side remark.


  <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