Page 1 of 1

What does role playing dimension mean?

Posted: 20 Jun 2016 2:24
by rupaali4
i am building a tiny project for my college and i am stuck here what to do now

thanks in advance

Re: What does role playing dimension mean?

Posted: 27 Jun 2016 7:36
by Nirmal
A single physical dimension can be referenced multiple times in a fact table, with each reference linking to a logically distinct role for the dimension. For instance, a fact table can have several dates, each of which is represented by a foreign key to the date dimension. It is essential that each foreign key refers to a separate view of the date dimension so that the references are independent. These separate dimension views (with unique attribute column names) are called roles. I found one more free resource https://intellipaat.com/nosql-cassandra-hbase-training/ which helps you in understanding the topic in depth.