Skip to main content

Use Identity Keys

Determines if Dimensions derived by the Dimensional Accelerator use identity-based surrogate keys. Alternatively, hash-based keys are used when this setting is disabled.

When enabled, derived Dimensions get an integer identity surrogate key named with the Append Identity affix. When disabled, hash-based keys named with the Append Surrogate Key affix are used instead — key strategy is this single toggle; there is no separate hash-key setting for the Data Mart.

When to Change This Setting​

Disable it when the Data Mart should use hash keys — for example to keep keys stable across reloads or environments, or on platforms where identity columns are undesirable.

SettingInteraction
Append IdentityThe key column affix used when identity keys are enabled
Append Surrogate KeyThe key column affix used when identity keys are disabled
Use Hash KeysThe Data Vault Accelerator's key-strategy setting

Notes​

  • This setting is part of the Data Mart settings category.
  • The default value for this setting is Y.