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
Similar topics
» Incremental Load Testing -Type 1 & Type 2
» rationale behind dimension with Type 0 and missing Type 5
» Type-2 Dates as Date Data Type ?
» Why do I need type 3 and 6 SCDs when I can implement type 7?
» Advice needed on fact table with multiple granularites
» rationale behind dimension with Type 0 and missing Type 5
» Type-2 Dates as Date Data Type ?
» Why do I need type 3 and 6 SCDs when I can implement type 7?
» Advice needed on fact table with multiple granularites
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|