Delta Stage All Rows
Enables delta process to stage all rows. When disabled, it compresses row changes into distinct rows by discarding full-row duplicates, retaining only the first row of sequential timestamps with identical values.
When enabled, the staging step skips the existence check against the PSA and the delta-detection logic, so every extracted row lands in the Staging table; delta row collapsing is also disabled.
When to Change This Setting
Keep the default N so only changed rows are staged and persisted. Enable it when the full extract should always be staged, for example when downstream steps consume the complete set of extracted rows rather than the delta.
Related Settings
| Setting | Interaction |
|---|---|
| Delta Collapse Rows | Row collapsing does not apply while all rows are staged |
| Truncate If Source Has Rows | Not applied while all rows are staged |
| Disable Stage, Persist Only | Combining both settings changes the generated load shape for ELT targets |
Notes
- This setting is part of the Staging Persistent settings category.
- The default value for this setting is
N.