2.2.2 Fact table
Fact table is the central table in a
multidimensional schema that contains measures or
metrics of business process or subject of the
analysis. Fact table accommodates numerical
values and foreign key to the dimension tables. In
addition to that, fact tables can record events at an
atomic level of detail (as they are designed to a low
level of granularity) [5, 10, 11]
2.2.3 Dimension tables:
Dimension table is the table that records the
attributes that describe the fact data [5].