Here I am trying to explain the methods to implement SCD types in BO Data Service. The different types of slowly changing dimension types are given below.

1.Type 0

2.Type 1

3.Type 2

4.Type 3

5.Type 4

6.Type 6/Hybrid.

In this document I will explain about first five types of SCD types with examples.

Source Data

NameIDatedesignation

John2002.12.01A

Jay2012.12.01A

Jasil2012.12.01A

SCD TYPE 0

The SCD Type 0 method is passive. Value remains the same as it were at the time the dimension record was first entered. Type 0 also applies to most date dimension attributes.

SCD TYPE 1

This method does not track any history data .This methodology overwrite old data with new data without keeping the history. This method mainly used for misspelled names.

Let consider below given data is our target data after the first run.

IDNameIDatedesignation

1John2002.12.01A

2Jay2012.12.01A

3Jasil2012.12.01A

During the next run, Consider the designation of John is changed to B on the date 2003.12.01 then the output will be.

IDNameIDatedesignation

1John2003.12.01B

2Jay2012.12.01A

3Jasil2012.12.01A