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

**URL:** <https://forum.data-community.org/t/what-will-be-cardinality-between-hub-sat-hub-links-links-links-tables/901>\
**Category:** Data Vault 2.0\
**Created:** [July 11, 2023, 8:25am UTC](https://forum.data-community.org/t/what-will-be-cardinality-between-hub-sat-hub-links-links-links-tables/901 "2023-07-11T08:25:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![notfound](https://avatars.discourse-cdn.com/v4/letter/n/dec6dc/32.png) [@notfound](https://forum.data-community.org/u/notfound)\
**Post date:** [July 11, 2023, 8:25am UTC](https://forum.data-community.org/t/what-will-be-cardinality-between-hub-sat-hub-links-links-links-tables/901/1 "2023-07-11T08:25:02Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![patrickcuba](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/patrickcuba/32/19_2.png) [@patrickcuba](https://forum.data-community.org/u/patrickcuba)\
**Post date:** [July 11, 2023, 11:24pm UTC](https://forum.data-community.org/t/what-will-be-cardinality-between-hub-sat-hub-links-links-links-tables/901/2 "2023-07-11T23:24:55Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![notfound](https://avatars.discourse-cdn.com/v4/letter/n/dec6dc/32.png) [@notfound](https://forum.data-community.org/u/notfound)\
**Post date:** [July 12, 2023, 11:15am UTC](https://forum.data-community.org/t/what-will-be-cardinality-between-hub-sat-hub-links-links-links-tables/901/3 "2023-07-12T11:15:58Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![patrickcuba](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/patrickcuba/32/19_2.png) [@patrickcuba](https://forum.data-community.org/u/patrickcuba)\
**Post date:** [July 13, 2023, 1:12am UTC](https://forum.data-community.org/t/what-will-be-cardinality-between-hub-sat-hub-links-links-links-tables/901/4 "2023-07-13T01:12:02Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![notfound](https://avatars.discourse-cdn.com/v4/letter/n/dec6dc/32.png) [@notfound](https://forum.data-community.org/u/notfound)\
**Post date:** [July 13, 2023, 6:21am UTC](https://forum.data-community.org/t/what-will-be-cardinality-between-hub-sat-hub-links-links-links-tables/901/5 "2023-07-13T06:21:12Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![RhysHanscombe](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/rhyshanscombe/32/394_2.png) [@RhysHanscombe](https://forum.data-community.org/u/RhysHanscombe)\
**Post date:** [December 1, 2025, 2:38pm UTC](https://forum.data-community.org/t/what-will-be-cardinality-between-hub-sat-hub-links-links-links-tables/901/6 "2025-12-01T14:38:25Z")

</div>

Closed on December 1, 2025, 2:38pm UTC