In EDW , say we have 1:M relationship between two tables so how this relationship cardinality will be changed in Data Vault modelling ?
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
Also what will be the cardinality between HUB-Sat Table ?
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?
Yes the state information will change and it could be possible to get more than one record