Fact Table

Fact Table

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:
  • Additive
  • Semi Additive
  • Non-Additive facts
Following are the types of Fact Tables:
  • Fact Less Fact Table
  • Cumulative
  • Snapshot
Leave A Comment

Please login to post your valuable comments.

Join the newsletter

Get the latest vLemonn news first