General Fact Table Dimension Measureable Store

Explain the fact table and the dimension table?   


VIBHA SANGINI
@[email protected] | Updated 23 Dec. 2018


Fact table: They are the measurable quantities or the numeric metrics of the data which can be analyzed by the dimension table. Facts are stored in the fact table contain foreign keys that uniquely refers to the associated dimension tables. The fact table is compatible to store the data at the atomic level and thus, it allows a large number of records to be inserted at once.




  Topics