Bridge Add Surrogate Key
Enables the use of a concatenated surrogate key in the Bridge table, comprising the Link keys.
When enabled (the default), the generated Bridge load computes a hashed surrogate key over the participating keys and selects it as the Bridge table's primary key column. When disabled, the surrogate key column is omitted, and BimlFlex waives the single-primary-key metadata validation for the Bridge object accordingly.
When to Change This Setting
Keep the default Y when consumers join to the Bridge through a single key column. Disable it to keep the Bridge as a plain combination of the participating keys without the extra hashed column.
Related Settings
| Setting | Interaction |
|---|---|
| Bridge Lag Days | The reprocessing window for the Bridge load |
| PIT Add Surrogate Key | The equivalent option for Point-In-Time tables |
| Hash Algorithm | The 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.