What is a Multi-Active Satellite? |
Multi-Active Satellites are used to store multiple entries per parent key; these records come from one denormalized data source. |
How to create a Multi-Active Satellite in 3D? |
We will use the example of employees operating in multiple territories to describe the steps required to create a multi-active satellite.
Data Vault Design |
This example incorporates data from 3 entities - Employee, EmployeeTerritories and Territories. Therefore, the query generates one row per Employee in each Territory (making the chosen Business Keys no longer unique).
REPLACE WITH THIS IMAGE: Resources/Images/satdesc.png
Note |
---|
|
Data Vault Model |
Generate the Data Vault model using the workflow buttons in combination with the default model conversion rules.
REPLACE WITH THIS IMAGE: Resources/Images/data_vault_model_909x589.png
- All of the extra DV control columns have been added to the entities as per DV 2.0 rules,
- Hub and Change hash keys have been added where needed.
- Naming standards have been applied as described when using the wizard. This includes a low rate of change (lroc) satellite and a multi active (ma) satellite.
- Data Types are only Logical at this stage.
Generate the Load and Staging model using the workflow buttons in combination with the default model conversion rules.
Load and Staging Model
REPLACE WITH THIS IMAGE: Resources/Images/load_stage_modell_918x691.png - Load and Stage tables have now been generated.
- Load tables extract from the original mapped source.
- Stage tables introduce the hash columns. The Extended Properties of the hash keys in the Stage table identify on which column(s) the hash key is based.
- Trace the Table Source of the DV tables to see the modelling lineage.
- Some data types appear a bit strange (e.g. tgt_???). These will be resolved in the next model step.
Generate the RED Export model using the workflow buttons in combination with the default model conversion rules. Then after reviewing the model export it to WhereScape RED.
Export to RED