Data Vault 2.0

Data Vault 2.0

Model an integration layer that absorbs new sources and keeps full history: hubs, links and satellites.

Outcome: You can turn a set of source systems into hubs, links and satellites that survive change.

1. 1

   Find the business keys and build hubs

   A hub is nothing but a business key, when it arrived and where it came from.

   Build it in the Model Builder · 12 min · instant checks

2. 2

   Connect hubs with links, describe them with satellites

   Relationships go in links, attributes and their history in satellites.

   Build it in the Model Builder · 15 min · instant checks

3. 3

   Integrate several sources into one hub

   Two systems that share a business key feed one hub, each with its own satellite.

   Build it in the Model Builder · 14 min · instant checks

4. 4

   Make the vault queryable with PIT and bridge tables

   Point-in-time and bridge tables pre-compute the joins the raw vault makes expensive.

   Build it in the Model Builder · 16 min · instant checks

5. 5

   From the vault to a star: build an information mart

   Dimensions and facts are views over hubs, links, satellites and PIT tables.

   Build it in the Model Builder · 16 min · instant checks