A table holding attribute information, such as dates or product names, that serves as an angle for analysis.
A table holding attribute information -- time, location, product, and so on -- that serves as an axis for analysis, referenced from a fact table. There's a recurring challenge around attributes that change over time, like a product's name -- one common answer is a design pattern called a slowly changing dimension (SCD), which preserves history by adding a new row instead of overwriting the old value.
© 2026 ITBGM