More advanced Link Object Staging Logic | VaultSpeed

More advanced link object staging logic

April 14th, 2019

Ba1a7016 1d6d 4296 a4bd fbdaa72780c9
Dirk Vermeiren
Ilustration More advanced Link Object Staging Logic
More advanced Link Object Staging Logic 2

Now what if this technical key was also put into the hub? This would result in one less lookup from the satellite to thehub. However, hubs should only contain business keys. It is good practice to put the technical key in the satellite but make it a special attribute that does not take part in the change of history. This means it will not be a part of the hash difference attribute calculation.

The target Data Vault model for this article is shown below.

More advanced Link Object Staging Logic 3



Spread the word