Archives of the TeradataForum
Message Posted: Fri, 19 Apr 2002 @ 14:00:56 GMT
| Subj: || || Nulls in a composite Primary Key deployed as a Primary Index |
| From: || || Anomy Anom |
<-- Anonymously Posted: Friday, April 19, 2002 09:55 -->
A proposed data model for multiple new DW base tables allows nulls in some of the columns involved in multiple 4-8 column composite
primary keys (because the data isn't 100% available from the source systems). This may or may not survive our modeling process, but I'd
welcome any feedback on deploying such a key as a primary index on Teradata.