Tuesday 22 December 2015

What are the types of SCD?

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

No comments:

Post a Comment