Type 3 Slowly Changing Dimension
Page 1 of 1 • Share •
Type 3 Slowly Changing Dimension
I am trying to find a best example / scenario where a type 3 scd would make more sense than a type 2. In my understanding type 3 can easily be derived from type 2.
If anybody has used type 3 dimension instead of type 2, please let me know the scenario and some reasoning why you used that.
Thanks for your time.
If anybody has used type 3 dimension instead of type 2, please let me know the scenario and some reasoning why you used that.
Thanks for your time.
kvkeee- Posts: 2
Join date: 2009-07-09
Re: Type 3 Slowly Changing Dimension
the only reason i would use type 3 is if i were interested in the last value or last fixed number values of an attribute.
generally speaking they have very little utility in real world data marts.
generally speaking they have very little utility in real world data marts.
rjp73- Posts: 4
Join date: 2009-07-24
Re: Type 3 Slowly Changing Dimension
Perhaps if you wanted to track the changing of 1 column. This could be useful for tracking customer upgrades downgrades where you wanted to know the customer's current product as well as their previous product.

BoxesAndLines- Posts: 621
Join date: 2009-02-03
Location: USA
Re: Type 3 Slowly Changing Dimension
or if the Company is acquired or acquires another company. If you want to maintain previous codes for reference. As mentioned by others Type 3 is rarely used, however certain situations do call for it.
Edwin Kurian- Posts: 13
Join date: 2009-02-03
Location: Milwaukee

Similar topics» Yes/No type questions asked in Symnatech
» How to load a Slowly Changing Dimension Type 2 with one SQL Merge statement in Oracle
» Not so slowly changing dimension attribute
» Type 3 Slowly Changing Dimension
» Loading Fact Table with Type 2 Slowly Changing Dimension
» How to load a Slowly Changing Dimension Type 2 with one SQL Merge statement in Oracle
» Not so slowly changing dimension attribute
» Type 3 Slowly Changing Dimension
» Loading Fact Table with Type 2 Slowly Changing Dimension
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum