Delta Collapse Rows
Enables row collapsing in Data Vault Satellite processing by retaining the first row of sequences with identical values and differing timestamps, discarding subsequent duplicates to enhance storage efficiency.
When enabled (the default), the generated Satellite load compares each incoming row's full-row hash against the preceding row for the same key (ordered by the effective-from date) and keeps a row only when its hash differs, so consecutive snapshots that carry no actual attribute change do not produce new Satellite rows. When disabled, the generated load processes rows without the collapse windowing logic.
When to Change This Setting
Keep the default Y for sources that deliver full or repeated snapshots, where many rows arrive unchanged. Consider disabling it only when the incoming data is already a true change-only feed, in which case collapse adds windowing work without removing rows; for fully derived deltas see ELT Delta Is Derived, which bypasses the collapse logic altogether.
Related Settings
| Setting | Interaction |
|---|---|
| ELT Delta Is Derived | When enabled, the source is treated as a pre-derived delta and the collapse logic is not applied |
| Uniform Change Type | Prevents rows that differ only by change type from being treated as changes |
Notes
- This setting is part of the Data Vault settings category.
- The default value for this setting is
Y.