Skip to the content
Data Vault 2.0
DV2 Data Warehouse Methodology

Data Vault Anti-pattern: Using varchar to store the HashKeys and HashDiffs

Saqib Ali | February 24, 2022

Why would you do that? HashKeys and HashDiffs are binary generated using a hashing algorithm like MD5 or SHA-1. Just store them as binary and effectively halve your storage and double your I/O! No need to convert them to the Char to store them as Varchar.

Categories: Data Vault Anti-patterns Tags: binary, HASHDIFF, Hashkey

Post navigation

← Data Vault Anti-pattern: Load Dates that are anything other than time of loading the Staging
Data Vault Anti-pattern: Creating Hubs for Dependent Children →
email saqib@dv2.org for guest post submissions