A fact based look at Hashing and Sequences and Collision Strategies in Data Vault 2.0 Standards.
Tag Archives: hashes
#datavault 2.0 and Hash Keys, Again?
Yet another dive in to Hash Keys and Data Vault 2.0
Joins, Natural Keys, Hashing MPP and #datavault
A walk back through the joins, hashing, Teradata, key selection, and arguments for and against sequence numbers. While this post is specifically related to Teradata, there are some generic statements here that apply to all MPP solutions.
#datavault 2.0 hashes versus natural keys
A short entry explaining the thought process behind the switch in DV2 away from sequences over to hash keys. Also describes some of the issues if Natural or Business keys are selected instead of hashes as PRIMARY KEYS in the Data Vault Model.