Skip to main content

Bridge Lag Days

Specify the number of days the Bridge process should go back and look for changes to reprocess.

The generated Bridge load rebuilds rows within this trailing window on each run, so late-arriving changes inside the window are incorporated. Values that are not valid numbers, or less than 1, are treated as 1.

When to Change This Setting

Keep the default 1 when loads run on schedule and upstream data arrives on time. Increase it when sources can deliver late corrections that need to be reflected in already-built Bridge rows — at the cost of reprocessing a larger window on every run.

SettingInteraction
Bridge Add Surrogate KeyKey structure of the Bridge table being reprocessed
PIT Lag DaysThe equivalent reprocessing window for Point-In-Time tables

Notes

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