Is it okay to have one than one LINK between the same HUBs? We have situation where we need the LINKs to be at two different grains:
- One at the LINE ITEM level called LINK_ORDER_LINE_ITEM_NODE
- One at the LINE ITEM Status level called
Is this an valid approach in Data Vault?
as the source supplies it so you too can model it
I see no reason why you could not have more than one link as long as it serves your auditability and/or reporting requirements. Make sure the UoW makes sense, if it does then go for it
Yes you can. The link that has the greater grain would have an additional column such as a degenerate hub.
If it is the same UoW one link but if the grain is different then you could have different links
Saqib, I’ve been traveling - so sorry for the late response.
The answer is “Absolutely!” As a reminder, because the Hub holds a distinct list of business keys for a specific concept, it may plan a role in any number of relationships, associations, events, or transactions - each at a different grain and each represented by a different link.