Up-Skill your Career with the world's effective online learning platform
Trusted by 200,000+ Satisfied Learners & 123+ Corporates
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.
- 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
In 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!
Subscribe For Free Demo
Free Demo for Corporate & Online Trainings.