Create a Link Satellite

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 Raw Vault 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: 

• Implementation Type

• Deduplication Method or Optimization Method (Only for Spark Generator)

• Deduplication Partition or Optimization Method Columns (Only for Spark Generator)
• ValidFrom Source Term
• File format (Only for Spark Generator)

Default Terms

A Link Satellite Model Object will include the following Default Terms:  

• BG_LoadTimestamp

• Link_HK

• BG_SourceSystem

• BG_ValidFromTimestamp

• BG_RowHash

• BG_ValidToTimestamp