Slowly Changing Dimension (SCD) Type 4

This diagram shows how a slowly changing dimension type 4 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 4 uses a history table to track the historical changes. This method is similar as database change capture or auditing table implementations.