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.