A dimension table, present in the star or snowflake schema, helps describe dimensions (dimension values, attributes, and keys) and is generally small in size (from several to a thousand rows).

The original intention of surrogate keys across multidimensional database designs was to help optimize joins by keeping all keys, used for joining between facts and dimensions, both numeric and single ...