Question: what is the difference between fact and dimension table with examples?
Answer: The fact table mainly consists of business facts and foreign keys that refer to primary keys in the dimension tables. A dimension table consists mainly of descriptive attributes that are textual fields. ... On the contrary, a fact table contains a foreign key, measurements, and degenerated dimensions.