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