A fact table stores quantitative information for analysis and is often denormalized. A fact table holds the measures, metrics and other quantifiable information. The different types of fact tables are as explained below: Read: Data Warehouse fact-less fact and Examples Slowly changing dimension Types of Dimension Tables in a Data Warehouse Types of Facts There are three types of facts: Additive Facts Additive facts can be used with any aggregation function like Sum(), Avg() etc. Example is Quantity, sales amount etc. Semi Additive Facts Semi-additive facts are those where only…