Slowly Changing Dimension type 1

Slowly Changing Dimension Type 1

In SCD Type1 the old data is overwritten by the new data. The old data is permanently deleted

Let us consider an example

EmpNo      Name       Location
1001             Mark           London

Consider Mark moves to Manchester. In SCD type 1 the old data is completely vanishes. So the data will be stored as


EmpNo      Name       Location
1001             Mark           Manchester

There are no traces of old location


Advantages:

SCD type 1 can be easily implemented as there is overwriting of the data and we don't store the historical data

Disadvantages:

The disadvantage of SCD type 1 is that the organisation doesn't where Mark worked before i.e., there is no trace that Mark worked in London


NOTE: SCD type 1 stores only current data