Heterogeneous Dimension
Lesson Notes
Heterogeneous Dimension Lesson Notes:
Video
Heterogeneous Dimensions
This type works when we have a case that a company selling different product to the same base of customer. Every product has it different attributes.
One famous example of this type assume an insurance company has two types of product like health and car. In this case Car insurance has different attributes than the health insurance.
If we tried to model this two different products this type name Heterogeneous dimensions.
Heterogeneous Dimensions
There are different scenario to implement this type
Separate Dimensions: Split each one in separate dimensions and facts. It will be less data and business will do this analysis from two separate facts.
Merge Attributes: We will merge all the attributes in one single table and we will add the common attributes and null for un related attributes. Implementing this scenarios when we have less different of attributes. However, this implementation is not recommended because of the table size, performance, and maintenance.
Generic Design: In this approach we will create a single fact table and single dimension with the common attributes. The problem of this design we will report or care about the common attributes only.
Further Reading
Dimensional Modeling: In a Business Intelligence Environment. The book is free, and you can download it from this link. You can read the following:
- Chapter 6.3.12 Heterogeneous products* page 292