Link

Links in Data Vault are specialized many-to-many relationship tables that connect two or more hubs, representing a unique business relationship or event. They primarily store the business keys of the connected entities and a load date timestamp, enabling the historical tracking of when relationships began and evolved without storing descriptive attributes.

S2V supports two types of links:

• Regular Links capture relationships between entities. They are designed to show a distinct list of all relationships that have ever existed between entities. See Link Definition.

• Non-Historized Links (often called transactional links) are used for high-volume, immutable event or transactional data where every occurrence of a relationship, even if the same entities are involved, is unique and important. They typically include additional business keys to define a unique grain and do not usually track changes to their descriptive attributes, as the data is considered static once recorded. See Non-Historized Link Definition.