Data vault connect multiple hubs into links, is it the best way using one link, or splitting the links is always a good way in data vault?

Question

I am transforming an existing star schema model into data vault. The main table contains 4 foreign keys coming from 4 different table. In data vault modelling techniques, what is the best practice in modelling such thing:

Use one link connecting the 4 tables hashed FK into the main table's hub?
Or using 4 links, each one is a relation between the main table and itself?

I am new to data vault and I didn't go through such thing when I learned about it.

score 3 · Accepted Answer · answered Jan 04 '21 at 14:52

3

You should respect the "unit of work", otherwise, you might create relationship that never existed.

Option one is the one you would want to implement.

Here's some lecture if you want. https://hanshultgren.wordpress.com/2011/05/04/unit-of-work-demystified/

answered Jan 04 '21 at 14:52

MLeblanc

1,816
12
21

so best way is one link connecting hubs altogether. – alim1990 Jan 05 '21 at 07:16
not only the best way, but how it should be. – MLeblanc Jan 05 '21 at 17:43

Data vault connect multiple hubs into links, is it the best way using one link, or splitting the links is always a good way in data vault?

1 Answers1