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.

You cannot use an Effectivity Link Satellite if you have bi-temporality in the source data (like two addresses valid simultaneously for the same BK).

No Terms should be added in an Effectivity Link Satellite. If you add some terms, they will be ignored during the code generation.

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