What are the differences between fact and dimension tables?

Question

Accepted Answer

Fact tables store quantitative data for analysis, while dimension tables store descriptive attributes related to facts.

Fact tables contain measurable, quantitative data (e.g., sales revenue, quantity sold).
Dimension tables contain descriptive attributes (e.g., product name, customer details).
Fact tables often have foreign keys linking to dimension tables.
Example: A sales fact table might include total sales, while a product dimension table includes product names and categories.
Fact tables are usually larger and more numerous than dimension tables.