Page 226 - Data Architecture

Chapter 6.2: Introduction to Data Vault Modeling
anything else. To understand the “changing of the business keys” from one line of
business to another, the data warehouse needs another table structure and another source
feed.

The next table structure that the data vault uses is called a link. The link structure houses
the feed from the manual process, FROM SLS123 TO ⁎P123MFG, otherwise known as a
same-as link structure.

An example Data Vault 2.0 model for this case is shown in Fig. 6.2.3.

Fig. 6.2.3 Data Vault 2.0 data model.

The hub customer represents the two keys found in the business process. The link same-
as shows their connection. The record source (Rec Src) shows “Joes Excel,” meaning the
data vault load processed an Excel spreadsheet based on the manual process. The link
satellite effectivity provides the time line for when the relationship between the two keys
starts and stops. Satellites are where the descriptive data live and breathe.

Satellites carry more than just effectivity. In the case of customer (not shown here), the
satellite may carry additional descriptive details such as the customer name, address, and
phone number. Other examples of satellites and satellite data are provided further in this
section.

226