Slowly Changing Dimension (SCD) Type 1

Kontext Kontext
visibility 166 access_time 2 years ago language English

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.
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

tag Tags
info Info
Image URL