Data Modeling - Data Vault - Satellite

1 - About

Satellite are tables in the data vault:

  • that hold all the descriptive attribute
  • and their history in a scd2 form

3 - Example

A satellite can be created from all descriptive attributes of a table source such as a customer

All extension table (i.e. with a 1:1 relationship) are by nature satellite table.

data/modeling/satellite.txt ยท Last modified: 2017/09/13 21:21 by gerardnico