Skip to main content

End Date Satellite

Determines if end dating is applied to the Data Vault Satellites.

When enabled, the generated Satellite loads maintain the effective-to date on superseded rows instead of relying on insert-only timelines. This requires the Satellite to carry a RowEffectiveToDate column modeled as a derived or source-provided satellite attribute; the generated logic adds the update statements that close off the previous row when a new version arrives.

When to Change This Setting​

Keep the default N for an insert-only Data Vault, where effectivity is resolved at query time (for example through the generated effectivity views). Enable it when consumers require a physical effective-to date on each Satellite row and you accept updates against the Satellite during loading.

Note that Satellites with end dating enabled are excluded from Satellite view generation: the current and effectivity views exist to serve the insert-only pattern.

SettingInteraction
Create Satellite ViewsCurrent/effectivity views are only generated for Satellites that are not end dated
Use TransactionsWrapping loads in transactions protects multi-statement update/insert sequences

Notes​

  • This setting is part of the Data Vault settings category.
  • The default value for this setting is N.