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