Mini Dimension

Solution to isolate rapidly changing SCD2 attributes on a wide dimensions.

Mini dimension is related to primary dimension through fact.

The Status and Income attribute in the dimension are causing the dimension to grow rapidly. Those attributes should be pulled into a mini dimension.

Dimensions will then be related through the Fact table.