Create an Effectivity Link Satellite

A Model Object of type Effectivity Link Satellite can be created in the Silver Layer.

What is an Effectivity Link Satellite

In a Data Vault model, an Effectivity Link Satellite is a particular Link Satellite type (See Create a Link Satellite). 

It is a standard Link Satellite housing temporal views of a Link.

In other words, one or more sets of beginning and end dates may dictate the effectiveness of the Relationship.

Creation steps

There are two possibilities to create an Effectivity Link Satellite Model Object:

• Create a Model Object with the Wizard:
  • Recommended possibility
  • Use the Wizard Create an Effectivity 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
    • Add to View
• Create a Model Object manually:
  • Not recommended possibility
  • Create a Model Object of type Effectivity Link Satellite in the Silver Layer
  • Create a Dataflow Set 
  • Add a Model Object to the Dataflow Set: add the Stage or Stage Composite Model Object
  • Don't add any Term
  • 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)

In each creation possibility, you should, after Effectivity Link Satellite creation: 

• Define the Effectiveness: map the Default Terms BG_Effectivity_Begin and BG_Effectivity_End to the source Terms, which contain the temporality information like a start date and an end date.

Properties

An Effectivity 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)
• File format (Only for Spark Generator)

Default Terms

An Effectivity Link Satellite Model Object will include the following Default Terms:  

• BG_LoadTimestamp

• Link_HK

• BG_SourceSystem

• BG_ValidFromTimestamp

• BG_RowHash

• BG_ValidToTimestamp

• BG_Effectivity_Begin
• BG_Effectivity_End

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 = {1}
• Terms amount: exclude Default Terms = {true}, exclude Business Keys = {true}, exclude Identities = {false}, exclude Foreign Keys = {true}, exclude unmapped Terms = {false}, min = {null}, max = {0}
• 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}