Data Architect Question:
Download Questions PDF

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'

Download Data Architect Interview Questions And Answers PDF

Previous QuestionNext Question
Tell us what is data mart?Tell me which schema is better – star or snowflake?