- Home
- Blog
- Data Warehousing
- Types Of Tables In DWH: Facts And Dimensions
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!
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 | Aug 23 to Sep 07 | View Details |
| Snowflake Training | Aug 26 to Sep 10 | View Details |
| Snowflake Training | Aug 30 to Sep 14 | View Details |
| Snowflake Training | Sep 02 to Sep 17 | View Details |
Last updated: 03 Apr 2023
About Author
Ravindra Savaram is a Technical 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 less
