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.
copyright
This page is subject to Site terms.
comment Comments
No comments yet.