imageSlowly Changing Dimension (SCD) Type 4

visibility 26 access_time 25 days ago languageEnglish

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.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

comment Comments
No comments yet.
tag Tags

info Info
Image URL
SVG URL
URL
More from Kontext
image Data Distribution Approaches in Parallel Computing System
visibility 112
thumb_up 0
access_time 8 months ago
Data Distribution Approaches in Parallel Computing System
image Slowly Changing Dimension (SCD) Type 3
visibility 24
thumb_up 0
access_time 25 days ago
Slowly Changing Dimension (SCD) Type 3