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.