Types Of Facts And Dimensions In Data Warehouse

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!

Job Support Program

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 MoreGet Job Support

Course Schedule

Name	Dates
Snowflake Training	Nov 23 to Dec 08	View Details
Snowflake Training	Nov 26 to Dec 11	View Details
Snowflake Training	Nov 30 to Dec 15	View Details
Snowflake Training	Dec 03 to Dec 18	View Details

Last updated: 03 Apr 2023

About Author

Ravindra Savaram

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