In this video, we will talk about Role playing dimension.
Role playing dimensions are type of dimensions that are used multiple times with different meaning and purpose. They appear several times in the same fact table with unique labels.
Recommended structure in warehouse is to create independent views for each fact table foreign key and label all the columns in each of the views uniquely.
Please share your thoughts and feedback.
Thanks for watching.