Fact table is a collection of business figures such as measurement, metrics for analysis. Generally fact tables contains two types of columns. First one is foreign key columns which is used to link fact data with dimension table. Second one is business facts.
Following are the types of Facts:
- Semi Additive
- Non-Additive facts
Following are the types of Fact Tables:
- Fact Less Fact Table