Delta Is Derived
Determines if a PSA table already receives a data delta. Enable this if loading into PSA and the delta has already been derived earlier. This will provide optimized ELT loads because no lookups are necessary.
When enabled, the generated load omits the delta-detection comparison against the PSA and the PSA history-correction steps: the incoming set is treated as a ready delta and applied directly.
When to Change This Setting
Keep the default N so the load derives the delta itself. Enable it when an upstream process already produces a clean delta for the object, removing the comparison work from the PSA load.
Related Settings
| Setting | Interaction |
|---|---|
| Delta Collapse Rows | Row collapsing does not apply to an already-derived delta |
| Bypass Persistent Checks | The equivalent lookup bypass for SSIS data flow loads |
Notes
- This setting is part of the Staging Persistent settings category.
- The default value for this setting is
N.