SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.

Ziek's SQL Home

Ezekiel is an IT professional with over ten years experience in building database applications and BI 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 solutions using the full stack and C#, Business Process Improvement and Project Risk Management. He is a Microsoft SQL Server Certified Professional.


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

Loading comments...