Saqib Ali, Certified Data Vault 2.1 Practitioner

Another excellent presentation on Data Vault Effectivity Satellites by Michael Olschimke, CEO of Scalefree.

So what is an Effectivity Satellite?

For an Effectivity Satellite, a Driving Key needs to be defined. For e.g. let’s say we have a Link for Opportunities and relations to Accounts. The Account on Opportunity can change overtime. A common scenario is that the Opportunity is Assigned to a Global Parent account (e.g. Seagate Technology), and may get re-assigned to the Account Subsidiary (e.g. Lyve Labs) and get re-assigned to the Global Parent (Seagate Technology) at a later date.

Another excellent overview of the de-normalization in Data Vault Raw Staging by Michael Olschimke, CEO of Scalefree. De-normalization is typically useful in loading LINK SATellites and Non-Historized (Non-Delta Driven) LINKS. Michael also covers challenges with de-normalization when using CDC.