Hash Binary
Determines if the generated hash value is stored as a binary representation or as a string representation.
When to Change This Setting
Enable (Y) when storage efficiency matters — Data Vault hubs with millions of rows benefit from the ~50% reduction in storage size that binary hashes provide compared to their hexadecimal string equivalents. Disable (N, the default) when you need human-readable hash values for debugging or when downstream SQL queries compare hashes as strings, since binary values require explicit conversion and are harder to inspect directly.
Related Settings
| Setting | Interaction |
|---|---|
| Hash Algorithm | Determines the algorithm used to generate the hash. The chosen algorithm affects hash length, which in turn affects storage size for both binary and string representations |
| Use SQL Compatible Hash | When comparing hashes generated by SSIS against SQL HASHBYTES() output, ensure the binary/string representation is consistent between both environments |
Notes
- This setting is part of the Core settings category.
- The default value for this setting is
N.