Slowly Changing Dimensions (SCD’s)
SCD is a dimension which captures the changes that occur over a period of time.
- Type I – Contains only current data. Change in source is overwritten
- Type II-Maintains complete history + Current data
- Type III-Partial (recent) history + Current data
In OLTP
Subscribe to our youtube channel to get new updates..!
In DWH
- Active record is where end date is null
- History
- Active status(Active record – Max Version)
- Change No (Version)
- Duration (Time stamp)