Slowly Changing Dimension (SCD) Type 1image

visibility 10 access_time 16 days ago languageEnglish

This diagram shows how a slowly changing dimension type 1 table is implemented. 

SCD Type 1 will simply overwrite old data with new data without keeping a history. 

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.

For SCD Type 1, surrogate ID is not necessary.

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