Tag "SCD"

Last Week Reading 0 Comments

Last Week Reading (2019-07-21)

Another week passed. Look what did I find during that time. Press British Airways faces record £183m fine for data breach The penalty imposed on BA is the first one

Last week reading (2018-12-02)

Hello folks, This is a quick roundup of Internet posts from last week. Have a good reading! Create and configure a self-hosted integration runtime This solution allows you integrate your

Data Warehousing 18 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