The difference between fact table and dimension table

In See most Dialog reporting tables also use a suffix to identify the table as a fact (_fact) table or a dimension table (_dim ) When you want to know the difference between the two tables, just search for it. The Fact table and the dimension table are two of the data Warehouse concepts, and are both types of data warehouse. From the point of view of saving data, there is no difference in nature, it is a table. The difference is that fact tables are used to store fact data, which are measurable data and additive data, number of data, amount, etc. Dimension table is used to store descriptive data that describes fact data, such as regions, sales reps, products, and so on.