Data Vault - Link

> (Data|State) Management and Processing > Data Modeling (RDBMS or Code)

1 - About

Typical examples of Links in the data vault methodology:

  • associations,
  • hierarchies,
  • and re-definition of business terms.

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

3.1 - 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.

3.2 - History

  • in a link satelitte
  • of as an attribute of a satellite
Advertising
data/modeling/link.txt · Last modified: 2017/09/13 21:21 by gerardnico