What is a Fact Table?
The Measureable event for the reference information is stored in the fact table.
A fact table in a Data Warehouse system is a table contains all the facts or the business information, which can be subjected to analysis and reporting activity when required.
A fact table consists of facts of a particular business process e.g., sales revenue by month by product. Facts are also known as measurements or metrics. A fact table record captures a measurement or a metric.
0 Comments