a look at address and people based business keys, how they are sticky, and the best possible solution to deal with them
In this entry I will explore the use of implementation of Data Vault on Teradata. However, this entry is applicable to everyone in the Data Vault community, as it covers definitions and descriptions of primary keys, indexing, surrogate keys, natural keys, and performance and tuning.
The more I go, the less I like the idea of composite business keys being candidates for Hubs. Here, I present a source system scenario, and explain how it plays out in creating a Data Vault as far as creating Hubs go.
Lengthy questions about the canonical structure, conceptual vs physical data vault modeling, Raw Data Vault vs business applications. An interesting read, please add your own comments to the end of this posting.
Discussion and answers about www.TDAN.com articles, some clarifications of statements I made in 2001/2002. I think you might find this interesting.