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).