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.
In other words SCD type 1 stores only current data.
