The Data Vault Handbook - Concepts and Applications

Non-historized Links like this provide a clear and efficient way to represent discrete, immutable events. By including contextual attributes such as the check-in time and reason for the visit directly in the Link, we avoid the com- putational overhead associated with managing granularity shifts. 3.2.2. MULTI-ACTIVE SATELLITES A Multi-Active Satellite is a variation of the standard Satellite used to store multiple active records for the same parent key at the same time. While a standard Satellite stores a single active record per key and time, a multi-ac- tive Satellite is designed to handle scenarios where multiple records related to the same business key can be valid simultaneously. A common example is an employee with multiple active phone numbers, where each phone num- ber needs to be uniquely identified and stored. A standard Satellite would only allow one active record per business key, causing issues when multiple records need to be stored. A Multi-Active Sat- ellite resolves the limitation by introducing a multi-active key, such as a sequence number or other identifier, allowing for the storage of multiple active records. This ensures that the data maintains its original granularity.

Remember

In a Multi-Active Satellite, the loading process occurs in “blocks”, where the hashdiff is computed for all records that share the same business key and load date timestamp.

In a Multi-Active Satellite, the loading process works in “blocks”, where the hashdiff is calculated for all records sharing the same business key and load date timestamp. When any of these active records change, the entire block is reloaded. This mechanism helps to keep track of which records are currently