Tag "SCD"

Data Warehousing 2 Comments

SCD type 1 & type 2 in MERGE statement

In my previous article, I have explained what does the SCD and described the most popular types of Slowly Changing Dimensions. I also mentioned that for one process, one table,

Data Warehousing 1 Comment

Slowly Changing Dimensions (SCD)

In today’s article I’d would like to focus on Slowly changing dimension, aka SCD. Dimension is a word excerpted from data warehousing as such. Not without a reason SCD is used