# Modelling transactions data with reference to 1 hub only

**URL:** https://forum.data-community.org/t/modelling-transactions-data-with-reference-to-1-hub-only/1302
**Category:** Data Vault 2.0
**Created:** [May 10, 2024, 9:37pm UTC](https://forum.data-community.org/t/modelling-transactions-data-with-reference-to-1-hub-only/1302 "2024-05-10T21:37:04Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![wml](https://avatars.discourse-cdn.com/v4/letter/w/9de053/32.png) [@wml](https://forum.data-community.org/u/wml)
#### Post date: [May 10, 2024, 9:37pm UTC](https://forum.data-community.org/t/modelling-transactions-data-with-reference-to-1-hub-only/1302/1 "2024-05-10T21:37:04Z")

</div>

Hi,

I’m new to Data Vault modelling and would appreciate some advice on how to model transaction data.

The source system provides Accounts and Account related transactions in 2 separate tables.

The Accounts table has a business key, Account Number, so I can model this as a hub.

The transactions table only has the Account Id and no other business keys. It also contains Transaction Type, Amount, Transaction Date, and it doesn’t have a unique identifier either.

As there is reference to only 1 business key, I don’t think I can model transactions as non-historised link.

What are the options in modelling this transaction table?

Many thanks

---

<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: [May 10, 2024, 10:43pm UTC](https://forum.data-community.org/t/modelling-transactions-data-with-reference-to-1-hub-only/1302/2 "2024-05-10T22:43:33Z")

</div>

> [@wml](#):
>
> What are the options in modelling this transaction table?

Here’s [one](https://patrickcuba.medium.com/data-vault-on-snowflake-expanding-to-dimensional-models-5eb67cbdcf4b)

---

<div class="post-metadata">

### Author: ![wml](https://avatars.discourse-cdn.com/v4/letter/w/9de053/32.png) [@wml](https://forum.data-community.org/u/wml)
#### Post date: [May 11, 2024, 9:25pm UTC](https://forum.data-community.org/t/modelling-transactions-data-with-reference-to-1-hub-only/1302/3 "2024-05-11T21:25:08Z")

</div>

Hi Patrick

I don’t have a membership with Medium so I can’t access the link.

---

<div class="post-metadata">

### Author: ![wml](https://avatars.discourse-cdn.com/v4/letter/w/9de053/32.png) [@wml](https://forum.data-community.org/u/wml)
#### Post date: [May 13, 2024, 1:29pm UTC](https://forum.data-community.org/t/modelling-transactions-data-with-reference-to-1-hub-only/1302/4 "2024-05-13T13:29:34Z")

</div>

Hi Patrick

Is there another site where I can access the article, please?