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
Enhance your IT skills and proficiency in Data Warehousing by taking up the Informatica Training.

In OLTP

Subscribe to our youtube channel to get new updates..!

OLTP

In DWH

DWH

  • Active record is where end date is null
  • History
  • Active status(Active record – Max Version)
  • Change No (Version)
  • Duration (Time stamp)
Explore Informatica Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!