PIT Lag Days
Specify the number of days the Point-In-Time process should go back and look for changes to reprocess.
The generated Point-In-Time load rebuilds snapshots 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 snapshots, at the cost of reprocessing a larger window on every run.
Related Settings
| Setting | Interaction |
|---|---|
| PIT Add Surrogate Key | Key structure of the Point-In-Time table being reprocessed |
| Bridge Lag Days | The equivalent reprocessing window for Bridge tables |
Notes
- This setting is part of the Data Vault settings category.
- The default value for this setting is
1.