facts and dimension tables

&nbsp;facts and dimensional tables are key component&nbsp; in a data warehouse.&nbsp;A fact table consist of records that combine attributes from different dimension tables. These records allows users to analyze different aspects of their business, which can aid in decision-making and improving the business.Dimension tables provide the context and background information for the measures recorded in the fact table. dimension tables contains the attributes that the measures in fact tables are based on.<b>CHARACTERISTICS OF A FACT TABLE</b>1. Outrigger Dimensions: these are dimension that refer to any other dimension table.2. Keys: Each fact table has a key that is made up of the primary keys from all of the dimension tables connected to the fact table3. Additive Measures: The fact table's attributes may entirely, partially, or not at all additive. measures that are applied to all dimension are referred to as fully addition or additive measures.4. Fact Table grain: The level of detail or depth of the information recorded in a fact table is referred to as the table grain5. Degenerated Dimension : is any dimension or attribute that is available in the fact table but cannot be added to or is non-additive6. Sparse Data: Some records in the fact table have characteristics with null values or measurement, which means that the information they contain is not given or provided.<b>CHARATERISTICS OF A DIMENSION TABLE</b><ol><li>The following are some of the characteristics of a dimension table:</li><li>1. Relationship between attributes: Although they are all included in the same dimension table, the attribute in it typically do not have a direct relationship with one another.</li><li>2. Records: The dimension table contains more characteristics than records</li><li>3. Keys:&nbsp; the main key is required for every dimension table in order to help uniquely identify each entry.</li><li>4. Attributes: because the dimension table has so may attributes, it looks to be expanding horizontally.</li><li>5. Attribute Values: the majority of the values in the dimension table are expressed as text rather than numbers.</li><li></li><li></li><li></li></ol>