A table in a DATA warehouse's star SCHEMA is referred to as a dimension table. Dimensional data models, which are made up of fact and dimension tables, are used to create data warehouses. Dimension tables contain dimension keys, values, and attributes and are used to describe dimensions. It is usually of a tiny size. The number of rows might range from a few to thousands. It is a DESCRIPTION of the objects in the fact table. The term "dimension table" refers to a collection or group of data pertaining to any quantifiable occurrence. They serve as the foundation for dimensional modelling. It includes a column that serves as a primary key, allowing each dimension ROW or record to be uniquely identified. Through this key, it is linked to the fact tables. When it's constructed, a system-generated key called the surrogate key is used to uniquely identify the rows in the dimension.

Following are the advantages of using a dimension table :

• It features a straightforward design.
• It is SIMPLE to study and comprehend.
• It stores data that has been de-normalized.
• It aids in the preservation of historical data for any dimension.
• It's simple to get info from it.
• It's simple to build and put into action.
• It provides the context for any business operation.