Types Of Tables In DWH: Facts And Dimensions

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

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