In "Building a Scalable Data Warehouse
with Data Vault
2.0" on page 358, I find these two statements:
1) 22.214.171.124 Storage Requirements - "When storing hashes, avoid using the varchar datatype."
2) 126.96.36.199 - 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?