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
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 | May 23 to Jun 07 | |
| Snowflake Training | May 28 to Jun 12 | |
| Snowflake Training | May 30 to Jun 14 | |
| Snowflake Training | Jun 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.
Recommended Courses
1 /5
Copyright © 2013 - 2022 MindMajix Technologies