Fact and Dimension Tables
There are so many articles regarding this topic. If you are up to a job title that is related to data warehousing, mark my words, you will definitely look for this topic. In my case, I will explain simply as I can which is short & sweet. What is a Fact Table? Fact Table is the table that contains the business numbers in a data warehouse. There are some cases in which is the numbers are in the Dimension Tables too. This table contains all the primary keys in the Dimension Tables as foreign keys. We can do aggregation on these Fact Tables. What is a Dimension Table? Dimension Tables are where all descriptive entities stores that describe the numbers in the Fact Table. In other words, the numbers in the Fact Table are described by the entities of the Dimension Tables. We can do filtering, grouping and labeling functions on these Dimension Tables. In data warehousing, we have to do some drilling through and slicing & dicing to get some results we need. For that
