Junk Dimension
Junk Dimension is used to records a collection of low-cardinality Flags and
Indicators data. Flag data may be non-generic question's answers like Yes/No or
True/False or Activate/Deactivate. Indicator data may be Height, Width, Weight,
Color, Status and other tiny text data.
To optimize database design, identify and eliminates low-cardinality Flags and
Indicators attributes from Fact table that collection of attributes should
recomposes in a Junk Dimension table. Junk Dimension is helps to avoid multiple
Foreign Key referential integrity between one Fact and many Dimension tables
into one Fact and one Junk Dimension table.
Multiple Junk Dimension tables need to design based on the collection of
low-cardinality complex structure. The following Online Sales Management System
Data Mart is designed with Sales_Fact that integrates with many shared dimension
tables.
Delivery_Type_Dimension is used to records Goods Delivery Type like "Van, Ship,
Truck, Train, Courier and Aircraft" data. Package_Type_Dimension is used to
records Product Packing Type like "Box, Tin, Bundle, Bottle and Container" data.
Package_Size_Dimension is used to records Product or Package "Height, Length,
Width and Weight" data.
To optimize this database design, eliminated Delivery_Type_Key, Package_Type_Key
and Package_Size_Key attributes from Sales_Fact table and then combine all
relevant dimension Flag and Indicator attributes into Delivery_Package_Dimension
table. Delivery_Package_Key attribute is introduced in the Junk Dimension that
integrates with Sales_Fact table.
Your Comment To AUTHOR
|
|