What will be cardinality between Hub-Sat , Hub-Links, Links-Links tables ?

Data Vault 2.0
1

In EDW , say we have 1:M relationship between two tables so how this relationship cardinality will be changed in Data Vault modelling ?

2

It won’t

If you’re particularly referring to associating relationships between business objects then the Link table contains all relationship types, 1:1, 1:M, M:M and even 1:0, controversially it could even contain 0:0, the clue on how that is done is in the notation I used

2 Likes
3

Also what will be the cardinality between HUB-Sat Table ?

4

that depends — are the state information about a business entity expected to change? If so then you’d expect more than one record for that entity in the sat, no?

5

Yes the state information will change and it could be possible to get more than one record