Types of tables in DWH: Facts and Dimensions

  • (4.0)
  •   |   705 Ratings

Tables in DWH


  • Dimensions are attributes about facts.
  • They store textual description about business.
  • Dimensions are denormalized due to one to many relationship

Ex: Store, Product, Employee, Customers

Enhance your IT skills and proficiency in Data Warehousing by taking up the Informatica Training.


Facts are the actual transactions or values being analyzed

  • They contain composite primary key where each attribute of primary key is foreign key to the dimension tables
  • A fact table contains the facts at the lowest level granularity


Prod Id, Cust Id, Sales Date are Dimension Keys.

Quantity Sold, Amount Sold are Fact Measures/KPI’s

KPI stands for Key Performance Indicators

Explore Informatica Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!


Popular Courses in 2018

Get Updates on Tech posts, Interview & Certification questions and training schedules