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 2: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 1: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 2: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.

BoxesAndLines

Posts: 621
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 2: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

View previous topic View next topic Back to top

- Similar topics

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