What is a Fact?
A fact is a column or attribute which can be quantifiable/measurable and will be used as key analysis factor. We can call it as a measure.
What is a Fact table?
A table which contains facts is called fact table. Typically a fact table has facts and foreign keys of dimension tables.
Fact table structure:
Fact table example:
Credit fact table has a reference to Customer dimension table and it has three facts (Credit_limit, Outstanding_amt, and Overdue_amt).
Types of Fact: