 |
 |
Archives of the TeradataForum
Message Posted: Wed, 15 Mar 2006 @ 23:04:19 GMT
| Subj: | | Re: AUTO_NUMBER in Teradata |
| |
| From: | | Victor Sokovin |
| | Is it a good idea first of all to define an customer_number primary key field based on identity column . | |
| | Secondly if people make copies of this table and come back to insert/update or recreate the table they Are loosing the original
numbers. | |
Exactly! This argument alone shows that autogenerated numbers are not suitable for such important key data as customer IDs. They are
practically worthless if live replication (dual architecture) is used. If the rules of generation are random you can end up with multiple IDs for
the same customer.
Regards,
Victor
| |
