CODEWITHSUNDEEP
data-modelingdata-warehousedata-vault
user957183
user957183

Reputation: 437

Is it mandatory that using Hub keys it should be able to uniquely indentify a record in satellite

I am a newbie in data vault modelling, I could not find a satisfying answer for the below query, pls help.

In Data Vault modelling, whether the below statement should met? If yes, should it be met 100%?

"The BKs in the Hub or Hubs should be such that, it should be sufficient to unique identify a record in the Satellite"

Thanks,

Upvotes: 0

Views: 321

Answers (1)

BarneyL
BarneyL

Reputation: 1362

The primary key of a satellite should be the key of the hub or link it attaches to plus the load date that row is inserted.

So you can have multiple entries in the satellite for one business key but you shouldn't have multiple entries for one point in time.

The above would also not be true in the case of a many to many relationship where there needs to be an additional field in the satellite primary key to make the rows unique (the classic example given is line number of multiple items within the same sale\invoice).

Upvotes: 1

Related Questions