Skip to main content

Cast Boolean to True False

Determines if the SQL inline hashing function for MSSQL, SQLDB and Synapse converts BIT (Boolean) values to True/False instead of 1/0.

The conversion applies where BimlFlex composes the hash input in generated SQL — staging row hashes and Data Vault hash keys — so boolean columns contribute the text True/False rather than 1/0 to the hashed value.

When to Change This Setting​

Keep the default N unless computed hashes must match a system that renders booleans as True/False. Changing it on an existing solution changes the hash values computed for rows with boolean columns.

SettingInteraction
Hash Null ValueThe NULL replacement used in the same hash input
String ConcatenatorThe separator used in the same hash input

Notes​

  • This setting is part of the Core settings category.
  • The default value for this setting is N.