Data Warehousing Questions
In data warehousing, a role-playing dimension refers to a dimension table that is used multiple times in a fact table, each time representing a different role or perspective. This allows for the analysis of data from different viewpoints without the need for creating separate dimension tables. For example, a date dimension table can be used to represent both the order date and the ship date in a sales fact table.