A Model Object of type Link Satellite can be created in the Silver Layer.
What is a Link Satellite
In a Data Vault model, a Link Satellite stores the context of a Link (See Create a Link), which is descriptive data.
Creation steps
There are two possibilities to create a Link Satellite Model Object:
- Create a Model Object with the Wizard:
- Recommended possibility
- Use the Wizard Create a Link Satellite from a Stage or a Stage Composite that contains the following steps:
- Create Model Object
- Create Dataflow
- Create Relations: number = {1}
- Map Foreign Key Terms
- Map selected Terms: exclude the Business Key(s) = {true}, exclude the Foreign Key(s) = {true}
- Add to View
- Create a Model Object manually:
- Not recommended possibility
- Create a Model Object of type Link Satellite in the Silver Layer
- Create a Dataflow Set
- Add a Model Object to the Dataflow Set: add the Stage Model Object
- Auto-map the Source Terms: select the auto-map mode and auto-map all the Source Terms except the ones defined as Business Keys and the Default Source Terms in the Source Model Object
- Add a Relationship to the corresponding Link
- 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 Satellite 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 Satellite Model Object will include the following Default Terms:
Business Rules
The following Business Rules are checked during the Model Object creation:
- Dataflows amount: min = {1}, max = {null}
- Dataflow Sets amount: min = {1}, max = {null}
- Dataflow Set Model Objects amount: min = {1}, max = {null}
- Relationships amount: min = {1}, max = {null}
- Relationships amount: min = {1}, max = {1}, related Model Object Types = {Link}
- Supported Term Data Types: exclude Default Terms = {true}, exclude Business Keys = {false}, exclude Identities = {false}, exclude Foreign Keys = {false}, exclude unmapped Terms = {false}
- Business Key Terms amount: min = {null}, max = {0}
- Identity Terms amount: min = {1}, max = {1}
- Identity Terms not nullable
- Supported Implementation Types: supported Implementation Types = {Permanent}
- Supported Deduplication Methods: supported deduplication Methods = {None, Distinct, Partition}
- Supported Load Cachings: supported Load Cachings = {Hashing}
- Foreign Key Mapping