Type 3 Slowly Changing Dimension

View previous topic View next topic Go down

Type 3 Slowly Changing Dimension

Post  kvkeee on Wed Jul 22, 2009 5:47 pm

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.

kvkeee

Posts : 2
Join date : 2009-07-09

View user profile

Back to top Go down

Re: Type 3 Slowly Changing Dimension

Post  rjp73 on Fri Jul 24, 2009 4:02 pm

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.

rjp73

Posts : 4
Join date : 2009-07-24

View user profile

Back to top Go down

Re: Type 3 Slowly Changing Dimension

Post  BoxesAndLines on Fri Jul 24, 2009 5:02 pm

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Type 3 Slowly Changing Dimension

Post  Edwin Kurian on Wed Jul 29, 2009 5:19 pm

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

View user profile http://www.valordevelopment.com

Back to top Go down

Re: Type 3 Slowly Changing Dimension

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum