Archives: May 2012
These datatypes particularly NVARCHAR(n), have been with us for some time now but having seen some of the confusion around when to use any of these, I feel oblige to share and infact to also learn more from anyone out there.
This data is used for storing a… Read more
I am wrapping up this series by finally considering the rarely used type 3 SCD.
( i.e. in most business scenarios)
Unlike the Type 2 SCD, the type 3 SCD tracks only the current value and the original value of a dimension member.
Two attributes are normally used in designing… Read more
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… Read more
SCD is a basically a concept that explains how historical data/values are stored within a data in a database.
There are three main scenarios namely Type I, Type II and Type III.
In this post, I will be discussing the Type I scenario and I promise to do the part… Read more