Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Ziek's SQL Home

Ezekiel is an IT professional with over ten years experience in building database applications and BI/DW solutions. He holds a BSc Computer Science degree from KNUST, Ghana and a MSc Business IT degree from Kingston Business School, London. He has delivered solutions for the Insurance, Banking, Telecom and Housing Industries and his key expertise include developing Microsoft BI/DW solutions, .NET applications, Business Process Improvement and Project Risk Management. He is a Microsoft Certified Professional - MCTS: Microsoft SQL Server 2005 Implementation and Maintenance.

Slowing Changing Dimension (SCD) demystified – Part 2

In Part 1 of this series, we looked at SCD Type I. We would now look at the SCD Type II.  Let’s assume the table below holds historical info of call plans of a customer in the Telecom industry.

Historical information storage (As a row)

From the table above it is easy to note that customer with ID = 5 had a previous call plan/service with an ID of 3  and he’s currently on a new call plan with an ID of 5.
Even though there has been a change in the call plan/service subscribed by the customer, these changes are still kept thus making it easy to track historical changes.  Thus in SCD Type II, the old values are kept and a new row is created for each change.
Type II is the most elegant way of storing historical information of dimension attributes because it is possible to store many old records without altering the underlying table structure.


Comments

Leave a comment on the original post [learnsqlwithezekiel.wordpress.com, opens in a new window]

Loading comments...