Dimension table is a compilation of categories, hierarchies, and logic which can further be used for the traverse purpose in hierarchy nodes. It includes textual attributes of measurements that are stored in fact tables.