Type 3 Slowly Changing Dimension
4 posters
Page 1 of 1
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 : 1212
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.
Similar topics
» What if Natural Key changes in a Slowly Changing Dimension Type 2?
» Loading Fact Table with Type 2 Slowly Changing Dimension
» Not so slowly changing dimensions
» Changing a slowly changing dimension
» Slowly Changing Dimension table
» Loading Fact Table with Type 2 Slowly Changing Dimension
» Not so slowly changing dimensions
» Changing a slowly changing dimension
» Slowly Changing Dimension table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum