Delta Is Late Arriving
Does the PSA load include late arriving deltas.
When enabled, the delta comparison joins against the full PSA timeline — matching on the primary key and the exact effective date — instead of only the current rows, so a row whose effective date falls before data that is already persisted is still detected. Matching late-arriving records are removed from the PSA and reloaded into their correct position in the timeline, and the current-row maintenance step of the standard delta load is skipped.
When to Change This Setting
Keep the default N when sources deliver changes in order. Enable it when a feed can deliver records whose effective timestamps lie before data that has already been loaded, so the PSA timeline is corrected rather than the late rows being discarded as old.
Related Settings
| Setting | Interaction |
|---|---|
| Truncate If Source Has Rows | Not applied while late-arriving processing is enabled |
| Select Stage Row Distinct | Adds a row-hash comparison to the late-arriving delta join |
Notes
- This setting is part of the Staging Persistent settings category.
- The default value for this setting is
N.