Type 7 SCD
3 posters
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

» Type-2 Dates as Date Data Type ?
» Incremental Load Testing -Type 1 & Type 2
» rationale behind dimension with Type 0 and missing Type 5
» Why do I need type 3 and 6 SCDs when I can implement type 7?
» Type 2 dimension or type 2 column?
» Incremental Load Testing -Type 1 & Type 2
» rationale behind dimension with Type 0 and missing Type 5
» Why do I need type 3 and 6 SCDs when I can implement type 7?
» Type 2 dimension or type 2 column?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|