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

Type 7 SCD

3 posters

Go down

Type 7 SCD Empty Type 7 SCD

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


Posts : 1
Join date : 2013-10-28

Back to top Go down

Type 7 SCD Empty Re: Type 7 SCD

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

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

Back to top Go down

Type 7 SCD Empty Re: Type 7 SCD

Post  BoxesAndLines Tue Oct 29, 2013 9:26 am

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

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

Back to top Go down

Type 7 SCD Empty Re: Type 7 SCD

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