Create a Record Tracking Satellite

A Model Object of type Record Tracking Satellite can be created in the Silver Layer.

What is a Record Tracking Satellite

In a Data Vault model, a Record Tracking Satellite is a particular Satellite type (See Create a Satellite). 

It is a raw Satellite that tracks when a record was seen in a source.

We can use this Record Tracking Satellite table to quickly identify the current records in a Satellite Result View.

Creation steps

There are two possibilities to create a Record Tracking Satellite Model Object:

• Create a Model Object with the Wizard:
  • Recommended possibility
  • Use the Wizard Create a Record Tracking 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 Record Tracking 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 Hub
  • 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 Record Tracking Satellite creation: 

• Define the tracking of the occurrence: map the Default Term BG_Appearance to the value 1.

Properties

A Record Tracking 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

A Record Tracking Satellite Model Object will include the following Default Terms:  

• BG_LoadTimestamp

• Hub_HK

• BG_SourceSystem

• BG_ValidFromTimestamp

• BG_ValidToTimestamp

• BG_Appearance

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}