Showing posts with label Dependent Child. Show all posts
Showing posts with label Dependent Child. Show all posts

Tuesday, March 15, 2022

Anti-pattern: Excluding the Dependent Child in the generating the LINK Hashkey

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.

Sunday, February 27, 2022

Anti-pattern: Creating Hubs for Dependent Children

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 be associated with an Order. This makes a Line Item a Dependent Child i.e. it is not a Business Concept on its own.

One way to model the Dependent Child is to add them in the Link as following: