If your LINKs have Dependent Childs, for e.g. Order Line Item as show below, it is crucial that the Order Line Item is included the LINK Hashkey.If the Dependent Child is not included the generation of the LINK Hashkey, the JOINs to the LINK table will not be easy.
Dependent Children should not have their own Hubs. They are not Business Concepts and as such should not be a Business Key by themselves. They only make sense when associated with a Business concept. One example is Line Items in a Order. The Line Item in Order by itself does not make sense. It needs to … Data Vault Anti-pattern: Creating Hubs for Dependent Children