Search code examples
data-warehousescd

How to implement SCD type 3

A customer is changing the address let say 5 times.

How to implement CUSTOMER dimension using slowly changing dimension type 3?

Solution

  • Well! I don't like to paste links in answers, but I think, answer is lengthy one and SCD Type 3 already has number of implementation examples available. See the following links:

    Implementing SCD Type 3 with SSIS

    and

    SCD Type 3 using SSIS