Greetings,

There is information regarding how to handle slowly changing dimensions
on the web. However there seems to be no treatment of slowly changing
sub-dimensions.

When a sub-dimension changes it triggers a tremendous ripple effect on
all dimensions that it attaches to when SCD-II approach is used.

Despite all anti-snowflaking propaganda there are many situations where
one needs to use a subdimension, especially when a dimension role-plays
in many other dimensions (Kimball gives the example of date dimension
but attributes really don't change in that scenario and doesn't really
count for my discussion), and may act as a regular dimension in some
other fact tables. Besides how are you planning to provide dimension
tables for summary tables if you do not snowflake?

How should we keep strict history while maintaining changes in
sub-dimensions as a new insertion of to the subdimension table causes
many row insertions to its associated dimension tables?

Thanks