Data Architect Question:
Download Job Interview Questions and Answers 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 Question | Next Question |
Tell us what is data mart? | Tell me which schema is better – star or snowflake? |