Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Type 3 Slowly Changing Dimension

4 posters

Go down

Type 3 Slowly Changing Dimension Empty Type 3 Slowly Changing Dimension

Post  kvkeee 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

Back to top Go down

Type 3 Slowly Changing Dimension Empty Re: Type 3 Slowly Changing Dimension

Post  rjp73 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

Back to top Go down

Type 3 Slowly Changing Dimension Empty Re: Type 3 Slowly Changing Dimension

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

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

Back to top Go down

Type 3 Slowly Changing Dimension Empty Re: Type 3 Slowly Changing Dimension

Post  Edwin Kurian 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

http://www.valordevelopment.com

Back to top Go down

Type 3 Slowly Changing Dimension Empty Re: Type 3 Slowly Changing Dimension

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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