Data Architect Question:
Explain me what is a role-playing dimension?
Answer:
Dimensions are often reused for multiple applications within the same database with different contextual meaning. For instance, a "Date" dimension can be used for "Date of Sale", as well as "Date of Delivery", or "Date of Hire". This is often referred to as a 'role-playing dimension'
| Previous Question | Next Question |
| Tell us what is data mart? | Tell me which schema is better – star or snowflake? |