Type 7 SCD

View previous topic View next topic Go down

Type 7 SCD

Post  sed78 on Mon Oct 28, 2013 11:04 pm

Iím new around here, so first of all: Hi!

I am currently designing our data warehouse and am investigating ways to persist historical data.

I have been looking at the different types of SCDís and am very taken by Type 7. It appears to be an elegant solution to many of the issues raised others. This said, I have not been able to find many references to type 7, or many examples of where they are used.

My question: Are type 7 SCDís known by another name? Also, how widely used are they? I would like to avoid a design with little information available.

Thanks for your help

sed78

Posts : 1
Join date : 2013-10-28

View user profile

Back to top Go down

Re: Type 7 SCD

Post  ngalemmo on Mon Oct 28, 2013 11:59 pm

I had always referred to it as having a type 1 and a type 2 dimension. †Nothing new, and it can be useful.

I see Ralph (or Margy) decided to put numbers to them, so be it... †But given there are a lot of numbers flying around (such as on Wiki) things will be confusing for a while.

Design Tip #152
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Type 7 SCD

Post  BoxesAndLines on Tue Oct 29, 2013 9:26 am

I've used that approach in the past with good success.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Type 7 SCD

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