Designing a Data Vault structure
Let's start with the modeling process. There are two ways to design a Data Vault, both using the same general approach. This approach consists of the following steps:
- Identify the business keys, the natural entities involved in the process you try to model. This creates the Hub tables.
- Identify the relationships between the created Hubs. This creates the Link tables.
- Identify the descriptive information to store in the data warehouse. Create Satellites to store this data.
- Possibly re-group the descriptive columns based on type, rate of change, or source system and create Satellite tables accordingly.
There are two starting points you can choose to start modeling a Data Vault structure. These are as follows:
- Translate a normalized database design into Hubs, Links, and Satellites.
- Determine the entities by analyzing the business processes to model.
The easiest way is to take an existing normalized source...
