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.
No Terms should be added in a Record Tracking Satellite. If you add some terms, they will be ignored during the code generation.
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 Raw Vault Composite that contains the following steps:
- 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 Raw Vault 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:
-
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: