Data Vault - Link

Datavault

About

A Link table in the data vault methodology is:

Every table which has more than one foreign key is a candidate to become a link.

Driving Key

The driving key is the main key that drives the rest of the relationship. She is arbitrarily assigned. The driving key is necessary to identify so that Satellites based on the Link can be appropriately “end-dated” when the relationship changes.

History

  • in a link satelitte
  • of as an attribute of a satellite





Discover More
Datavault
Datawarehouse Data Modeling - Data Vault

The data vault (DV) is a relational data model technique used in the persistence layer of a datawarehouse The Data Vault consists of three primary entity types: ...



Share this page:
Follow us:
Task Runner