 |
 |
Archives of the TeradataForum
Message Posted: Sat, 11 Apr 2009 @ 22:09:10 GMT
| 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.
Victor
| |
