11 Replies Latest reply: Nov 7, 2012 1:57 AM by jagan mohan rao appala RSS

    Dimension with no unique key

      i have a dimension without a unique key.

      say for example, in Customer dimension, one customer can belong to many REP’s in same State.

      how can I join this dimension with my Transactions fact table?

      Ex Customer Table:

      Customer1,State1,REP1

      Customer1,State1,REP2

      Customer1,State1,REP3…..

       

      so, any ideas to generate a unique key in this scenario?