Data Warehouse Manager Interview Question:

Tell me what are the types of SCD?

Submitted by: Muhammad

There are three types of SCD and they are as follows:

SCD 1 – The new record replaces the original record

SCD 2 – A new record is added to the existing customer dimension table

SCD 3 – A original data is modified to include new data
Submitted by: Muhammad