Fact Table | Dimension Table Sr Fact Table Dimension Table 1 Measurements, metrics or facts about a business process. Companion table to the fact table contains descriptive attributes to be used as query constraining. 2 Located at the center of a star or snowflake schema and surrounded by dimensions. Connected to the fact table and located at the edges of the star or snowflake schema 3 Defined by their grain or its most atomic level. Should be wordy, descriptive, complete, and quality assured. 4 Fact table is a measurable event for which dimension table data is collected and is used for analysis and reporting. Collection of reference information about a business. 5 Facts tables could contain information like sales against a set of dimensions like Product and Date. Evert dimension table contains attributes which describe the details of the dimension. E.g., Product dimensions can contain Product ID, Product Category, etc.
