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

SCD type 1 can be easily implemented as there is overwriting of the data and we don't store the
historical data
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.

In other words SCD type 1 stores only current data.