Modelling transactions data with reference to 1 hub only


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

Here’s one

Hi Patrick

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

Hi Patrick

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