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!

On-Job Support Service

Online Work Support for your on-job roles.

@Learner@SME

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	Mar 25 to Apr 09	View Details
Snowflake Training	Mar 29 to Apr 13	View Details
Snowflake Training	Apr 01 to Apr 16	View Details
Snowflake Training	Apr 05 to Apr 20	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