what is difference between dimensions and facts?
A dimension table consists mainly of descriptive attributes that are textual fields. When comparing the size of the two tables, a fact table is bigger than a dimensional table. In a comparison table, more dimensions are presented than the fact tables. In a fact table, less numbers of facts are observed.