Fact and dimension tables

Fact table contains numerical data, it is a numeric attribute of a fact, it contains measures that can be summed up to analyze or to carry out some process and they are primarily joined to dimension table through foreign keys. The fact table contains the description of the primary key of all tables and it is in normalized form Dimension table have qualitative data, they provide context and background information. It holds attributes that are used to define the set of object for analysis and they are not in normalized form