Dimension Table

A dimension table is a type of data table used in data warehousing that provides descriptive information about the main data being analyzed, such as dates, products, or locations. It helps organize and categorize data, making it easier to interpret and analyze. For example, a sales fact table might record sales transactions, while dimension tables would describe products, customers, or time periods. This setup allows users to generate meaningful reports and insights by connecting detailed facts to their related descriptive context in a structured way.