Bypass Persistent Checks
Enable this to bypass lookups, and directly applies all records to the Staging and Persistent Staging tables.
In the generated SSIS load, enabling this removes the PSA lookup and the initial-load check; the data flow instead multicasts every incoming row to both the Staging and the Persistent Staging targets directly.
When to Change This Setting
Keep the default N so the PSA lookup filters out records that are already persisted. Enable it when the incoming feed is guaranteed to contain only new records, trading the delta safety check for load speed: records that were already persisted would otherwise be applied again.
Related Settings
| Setting | Interaction |
|---|---|
| Delta Is Derived | The equivalent already-a-delta optimization for ELT loads |
| Delta Detection in SQL | The bypass data flow is not generated when SQL-based delta detection is used |
| Disable Stage, Persist Only | The bypass data flow is not generated when the Staging table is disabled |
Notes
- This setting is part of the Staging Persistent settings category.
- The default value for this setting is
N.