|
|
Archives of the TeradataForum
Message Posted: Tue, 03 Jan 2006 @ 18:24:24 GMT
Subj: | | Re: Handling a 64 bit ID |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Tuesday, January 03, 2006 13:08 -->
| The project has a requirement for a 64-bit number as the ID for each of the tables (A 32-bit value from a Source seed and a 32-bit value
from another Source seed). | |
An entity may have multiple identifiers. Why not create a surrogate identifier and simply store the two IDs supplied as basic attributes from
two separate source systems as attributes.
Anonym
| |