Data Warehouse Manager Question:
Tell me what are the types of SCD?
Answer:
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
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
| Previous Question | Next Question |
| Explain me what is Metadata? | Tell me what are Non-additive facts? |