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:

1. Identify the business keys, the natural entities involved in the process you try to model. This creates the Hub tables.
2. Identify the relationships between the created Hubs. This creates the Link tables.
3. Identify the descriptive information to store in the data warehouse. Create Satellites to store this data.
4. 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...