A Model Object of type Link can be created in the Silver Layer.
What is a Link
In a Data Vault modeling, a Link integrates the Business Keys and stores the relationships between them, themselves stored in Hubs (See Create a Hub).
Creation steps
There are two possibilities to create a Link Model Object:
- Create a Model Object with the Wizard:
- Recommended possibility
- Use the Wizard Create a Link from a Stage or a Raw Vault Composite that contains the following steps:
- Create Model Object
- Create Dataflow
- Create Relations: number = {null}
- Map Foreign Key Terms
- Add to View
- Create a Model Object manually:
- Create a Model Object of type Link in the Silver Layer
- Create a Dataflow Set
- Add a Model Object to the Dataflow Set: add the Stage or Raw Vault Composite Model Object
- Add a Relationship to the corresponding Hubs (at least 2 Hubs)
- Edit the Foreign Key Terms: set them as Business Key
- Map the Foreign Key Terms: select the target mode and manually map the Foreign Key Terms to the corresponding Source Terms (with or without a complex expression)
Properties
A Link Model Object can be configured through the following Properties:
-
Deduplication Method or Optimization Method (Only for Spark Generator)
- Deduplication Partition or Optimization Method Columns (Only for Spark Generator)
- File format (Only for Spark Generator)
Default Terms
A Link Model Object will include the following Default Terms: