Skip to main content

Create Satellite Views

Generate easy-to-use Data Vault Satellite views that include effectivity timelines and current statuses, making it simpler to analyze your data over time.

When enabled, BimlFlex generates two views per Satellite (including Link Satellites and Reference Satellites): a current view returning the latest row per key, and an effectivity view deriving an effective-to date per row from the following row's effective-from date. View names are built as {prefix}{table name}{suffix} from the Prefix View Name, Current View Suffix and Effectivity View Suffix settings. Satellites with End Date Satellite enabled are skipped, since their rows already carry a physical effective-to date.

When to Change This Setting​

Keep the default N if consumers query the raw Satellites or you build your own presentation layer. Enable it to get ready-made current/history access on top of an insert-only Satellite design without hand-writing the windowing SQL.

SettingInteraction
Prefix View NamePrefix for the generated view names (default vw_)
Current View SuffixSuffix for the current views (default _CURR)
Effectivity View SuffixSuffix for the effectivity views (default _EFDT)
End Date SatelliteEnd-dated Satellites are excluded from view generation

Notes​

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