SCD Type 1, SCD Type 2, SCD Type 3,Slowly Changing Dimension Types,Advantages & Disadvantages

The Slowly Changing Dimension problem is a common one particular to data warehousing.There are in general three ways to solve this type of problem, and they are categorized as follows:

• Type 1: The new record replaces the original record. No trace of the old record exists. Read more
• Type 2: A new record is added into the customer dimension table.Thereby, the customer is treated essentially as two people. Read more
• Type 3: The original record is modified to reflect the change. Read more