Type 7 SCD
Page 1 of 1
Type 7 SCD
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
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
Re: Type 7 SCD
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
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
Re: Type 7 SCD
I've used that approach in the past with good success.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|