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
- Slowly Changing Dimensions ( SCD Type I/II/III )
- Types Of Facts In Data Warehouse
- 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
Tables in DWH
Dimensions:
- Dimensions are attributes about facts.
- They store textual description about business.
- Dimensions are denormalized due to one to many relationships
Ex: Store, Product, Employee, Customers
Enhance your IT skills and proficiency in Data Warehousing by taking up the Informatica Training.
Facts:
Facts are the actual transactions or values being analyzed
- They contain composite primary key where each attribute of a primary key is a foreign key to the dimension tables
- A fact table contains the facts at the lowest level granularity
FACT:
- Prod Id, Cust Id, Sales Date are Dimension Keys.
- Quantity Sold, Amount Sold is Fact Measures/KPI’s
- KPI stands for Key Performance Indicators
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 | Sep 26 to Oct 11 | View Details |
| Snowflake Training | Sep 30 to Oct 15 | View Details |
| Snowflake Training | Oct 03 to Oct 18 | View Details |
| Snowflake Training | Oct 07 to Oct 22 | View Details |
Last updated: 24 September 2023
About Author
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.
read more
Copyright © 2013 - 2023 MindMajix Technologies
Try NOW: One-Access by MindMajix