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 ?

       

      Thanks

      Amir