What Does Dimension Table Mean?
A dimension table is a database table referencing defining pieces of information or attributes for particular records in a primary database table. Experts may describe a dimension table as part of a “database schema” or a database conceptual map that shows the logical construction of the database. Typically, any dimension table has a primary key that links all of the dimension records to the individual primary records.
Techopedia Explains Dimension Table
The idea with dimension tables is that users can do specific and precise queries to filter and group dimension information for research and business intelligence purposes. The use of a surrogate key helps to join the dimension data to the data from the primary record.
