In "Building a Scalable Data Warehouse
with Data Vault
2.0" on page 358, I find these two statements:
1) 188.8.131.52 Storage Requirements - "When storing hashes, avoid using the varchar datatype."
2) 184.108.40.206 - Tool and Platform Compatibil
ity - "For that reason, the recommended datatype to store hash keys is varchar..."
My head hurts :)
I understand the reasoning behind both statements. What IS the recommended best practice?