Difference between SCD Type2 and SCD Type3

Type2 SCD:
Type2 SCD maintains full historical information by adding a new row to the existing row.
In DWH we use to implement the type2 SCD because it maintains the full historical information.
One disadvantage with type2 SCD is the size of the database is going to increase hence it shows the performance degrader.
Type3 SCD:

It maintains the partial history by adding a new column to the existing row.

Leave a Reply

Your email address will not be published.