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!
Join our newsletter
.svg&w=750&q=75)
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
| Name | Dates | |
|---|---|---|
| Snowflake Training | Apr 01 to Apr 16 | |
| Snowflake Training | Apr 04 to Apr 19 | |
| Snowflake Training | Apr 08 to Apr 23 | |
| Snowflake Training | Apr 11 to Apr 26 |
Last updated: 31 March 2023
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.
Copyright © 2013 - 2023 MindMajix Technologies