2 Replies Latest reply: Jan 8, 2017 10:52 AM by Vineeth Pujari RSS

    Fact with more than one surrogate key to the same Dimension table

    Amir Kachlon

      Hi all,


      I have a general question:


      assume that I have one Fact table with 3 fields of item hierarchy, as follow


      Grand Father Item | Father Item | Item

      123                         | 12               | 1


      now I want to connect each one of them to Dim Item.


      I see two options:


      1. duplicate dim item 3 times

      2. transpose the table so each row of data will have 3 repetitions, for each item in hierarchy, of course I will add another column to handle the hierarchy


      both of the solutions seems wasteful


      anyone has a better suggestion ?