Data Vault model
- Model the Hubs – Understanding of BK’s and its usage across the business (also create hash keys)
- Model the Links – Establish the relationship between the business keys, hash keys and enhance the creation of link tables
- Model the Satellites – Provide the context (descriptive details) to each business keys from Hubs as well as link tables
- group them by
- rate of change
- type of information and
- by Source System
- group them by
- Standalone objects (like calendars) as a reference tables
- Add performance tables (Point in time and bridge tables)
- Information Mart (Dimensional Model – Data Marts) – For reporting
Data Vault model – Support Evolution
- supports incremental extension to the model)
- Suppose we have business model 1:M relationship and later it is changed to M:M, the link table already takes care of it. Because it is already sitting like a bridge table.
- Final data mart can easily be reloaded (full sync). Keys won’t get disturbed when adding more context
- Allow easy to update records.
Including Satellites
Data Vault – Why and Today’s Challenges
