A Link table in the data vault methodology is:
- and re-definition of business terms.
Every table which has more than one foreign key is a candidate to become a link.
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.
- in a link satelitte
- of as an attribute of a satellite