Slowly Changing Dimension (SCD) Type 3

This diagram shows how a slowly changing dimension type 3 table is implemented.

customer_number is the business key of the customer table while customer_id is a surrogate key. Customer 10001 is changing first_name from Kontext to Context.

SCD Type 3 will add a new attribute to keep the current value. The drawback is that it can only keep previous and current values only.

For SCD Type 3, surrogate ID is not necessary.