What is the difference between a fact table and a dimension table?
1Times asked
Aug 2026Last seen
Aug 2026First seen
💡 Model Answer
A fact table contains measurable, quantitative data about business events, such as sales revenue or units sold, and is linked to dimension tables via foreign keys. Dimension tables hold descriptive attributes that provide context for the facts, like product details, customer information, or time periods. Fact tables are typically large, highly normalized, and designed for aggregation, while dimension tables are often denormalized to support efficient querying and reporting.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.
Get Assisting AI — Starts at ₹500