Open ataft opened 1 year ago
Order Dim should be eliminated in favor of Status Dim and a Degenerate dimension for order number.
The header/line pattern is expanded on here: https://www.kimballgroup.com/2007/10/design-tip-95-patterns-to-avoid-when-modeling-headerline-item-transactions/
Degenerate dimensions: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/degenerate-dimension/
Order Dim should be eliminated in favor of Status Dim and a Degenerate dimension for order number.
The header/line pattern is expanded on here: https://www.kimballgroup.com/2007/10/design-tip-95-patterns-to-avoid-when-modeling-headerline-item-transactions/
Degenerate dimensions: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/degenerate-dimension/