Data Vault Links (1:n relaiton)

Data Vault 2.0
1

Hello

I am currently working with raw data in Snowflake, I have a table contains two BK’s that their relationship is 1:n

I faced an issue for example, my raw data gets updated frequently. An account that holds account_id and account owner, then it changes to a new owner but later on it changes back to the older account owner.

Inside the Link (as I assume we can not have multiple CDC inside the Link)
I want to see whenever they connected in the Links (account_id with account owner) which in the previous example happened multiple times. What would be the best practice to work around this?

I have read that you can create a SAT for the link that contains that part of information but that defeats the purpose of a DV doesn’t it?

Many thanks!

2

Hi, you are indeed correct, in Data Vault the structure that is responsible for holding the context of the information we are storing is the satellite, and in this case you want to store the context or information about a relationship between 2 business entities represented in 2 different hubs.
For these cases is recommended to use a link-satellite that store the context of this relationship.
You can read more about this here: Data Vault Link-Satellite Explained – Everything You Need to Know

3

You might need to define a driver key and manage an effectivity satellite

2 Likes