a look at address and people based business keys, how they are sticky, and the best possible solution to deal with them
Tag Archives: Links
Notes on Data Vault and Teradata
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.
#datavault Pirates, Peg Leg Links and Business Keys
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.
Conceptual, Canonical, and Raw Data Integration
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.
Questions about Data Vault from a friend
Discussion and answers about www.TDAN.com articles, some clarifications of statements I made in 2001/2002. I think you might find this interesting.