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

Rating: 4

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.



MindMajix Youtube Channel



  • 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!



Join our newsletter

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
Snowflake TrainingApr 23 to May 08View Details
Snowflake TrainingApr 27 to May 12View Details
Snowflake TrainingApr 30 to May 15View Details
Snowflake TrainingMay 04 to May 19View Details
Last updated: 03 Apr 2023
About Author

Although from a small-town, Himanshika dreams big to accomplish varying goals. Working in the content writing industry for more than 5 years now, she has acquired enough experience while catering to several niches and domains. Currently working on her technical writing skills with Mindmajix, Himanshika is looking forward to explore the diversity of the IT industry. You can reach out to her on LinkedIn


read more