ELT Delta Is Derived
Enable if loading into Data Vault and the Delta has already been derived. This will provide optimized ELT loads for scenarios like streams or insert-only transaction source tables.
When enabled, the generated Satellite load treats the incoming data as the delta: the current-row comparison against the target Satellite and the row-collapse windowing are skipped, and a reduced set of load statements is generated that stages and inserts the delta directly.
When to Change This Setting
Keep the default N for regular sources, where BimlFlex derives the delta by comparing incoming rows against the current Satellite content. Enable it when the source is guaranteed to only deliver new changes — for example event streams or insert-only transaction tables — so the load skips the comparison work it does not need.
Related Settings
| Setting | Interaction |
|---|---|
| Delta Collapse Rows | Collapse logic is bypassed when the delta is pre-derived |
Notes
- This setting is part of the Data Vault settings category.
- The default value for this setting is
N.