Diagram Kontext Kontext

Slowly Changing Dimension (SCD) Type 1

event 2022-07-23 visibility 226 comment 0
more_vert

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.

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
SVG URL