Home  >  Blog  >   Data Warehousing  > 

Types Of Tables In DWH: Facts And Dimensions

Rating: 4
  
 
7773

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

MindMajix Youtube Channel

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
inbox

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
NameDates
Snowflake TrainingJan 31 to Feb 15
Snowflake TrainingFeb 04 to Feb 19
Snowflake TrainingFeb 07 to Feb 22
Snowflake TrainingFeb 11 to Feb 26
Last updated: 29 January 2023
About Author
Remy Sharp
Ravindra Savaram

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.