primary key options for data vault 2.0 this entry is a candid look (technical, unbiased view) of the three alternative primary key options in a data vault 2.0 model. there are pros and cons to each selection. i hope you enjoy this factual entry. (more…)
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.
a quick q&a about the choices i made in the northwind data model, particularly regarding the data vault i wrote about in 2001.
discussion and answers about www.tdan.com articles, some clarifications of statements i made in 2001/2002. i think you might find this interesting.