Currently the DW has standard dimensions, for customer and product these are Type 1 SCD.
Mini dimensions have been created for changing hierarchy data on these dimensions (Type 2 SCD).
E.g. For customer the mini dimension is:
Cust_bus_hier_sk, cust_sk, <Customer Acc No, Cust Group, Business...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.