Mindmajix

Slowly Changing Dimensions ( SCD Type I/II/III )

Slowly Changing Dimensions (SCD’s)

SCD is a dimension which captures the changes that occur over a period of time.

  1. Type I – Contains only current data. Change in source is overwritten
  2. Type II-Maintains complete history + Current data
  3. Type III-Partial (recent) history + Current data

 

In OLTP

Screenshot_11

In DWH

Screenshot_12

  • Active record is where end date is null
  • History
  • Active status(Active record – Max Version)
  • Change No (Version)
  • Duration (Time stamp)

0 Responses on Slowly Changing Dimensions ( SCD Type I/II/III )"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.