Skip to main content

PIT Add Surrogate Key

Enables the use of a concatenated surrogate key in the Point-In-Time table, comprising the Hub key and the RowEffectiveFromDate.

When enabled (the default), the generated Point-In-Time load computes a hashed surrogate key from the Hub key and the snapshot's effective-from date and maintains it as the PIT table's key column through the merge logic.

When to Change This Setting​

Keep the default Y when downstream consumers (such as Bridge tables or presentation-layer joins) benefit from a single-column key per PIT snapshot row. Disable it to omit the extra key column and its hash computation.

SettingInteraction
PIT Lag DaysThe reprocessing window for the Point-In-Time load
Bridge Add Surrogate KeyThe equivalent option for Bridge tables
Hash AlgorithmThe algorithm used to compute the surrogate key hash

Notes​

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