Home  >  Blog  >   Data Warehousing  > 

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

Rating: 4
  
 
3190

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

OLTP

MindMajix Youtube Channel

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!

 

 

Join our newsletter
inbox

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
NameDates
Snowflake TrainingMay 23 to Jun 07
Snowflake TrainingMay 28 to Jun 12
Snowflake TrainingMay 30 to Jun 14
Snowflake TrainingJun 04 to Jun 19
Last updated: 09 Apr 2022
About Author
Himanshika Sharma

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