Slowly Changing Dimension (SCD) Type 3image

visibility 17 access_time 16 days ago languageEnglish

This diagram shows how a slowly changing dimension type 3 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 3 will add a new attribute to keep the current value. The drawback is that it can only keep previous and current values only.

For SCD Type 3, 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
[Diagram] AWS ETL Solution with Glue Diagram image
visibility 257
thumb_up 0
access_time 6 months ago
AWS ETL Solution with Glue Diagram
[Diagram] Data Engineering - Transactional Extract image
visibility 23
thumb_up 0
access_time 8 months ago
Data Engineering - Transactional Extract