- Home
- Blog
- Data Warehousing
- Slowly Changing Dimensions ( SCD Type I/II/III )
Data Warehousing Articles
- Data Warehouse Interview Questions
- Data Warehouse Tools
- Data Warehouse vs Data Lake
- Data Acquisition – ETL Process In Data Warehousing
- DWH Life Cycle
- Types Of Facts In Data Warehouse
- Types Of Tables In DWH: Facts And Dimensions
- What Are Differences Between OLTP And DWH?
- What is Confirmed, Shrunk Dimensions
- What Is Data Mart?
- Data Warehousing?
- OLTP VS OLAP - Difference between OLTP and OLAP
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!
On-Job Support Service
Online Work Support for your on-job roles.
Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:
- Pay Per Hour
- Pay Per Week
- Monthly
Learn MoreContact us
Course Schedule
| Name | Dates | |
|---|---|---|
| Snowflake Training | May 06 to May 21 | View Details |
| Snowflake Training | May 10 to May 25 | View Details |
| Snowflake Training | May 13 to May 28 | View Details |
| Snowflake Training | May 17 to Jun 01 | View Details |
Last updated: 28 Sep 2024
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 less
