11 Replies Latest reply: Sep 7, 2015 10:24 AM by Gysbert Wassenaar RSS

    How to deal with more than two fact all with different columns and keys

    kumar avisakula

      Hello Experts,

       

      I have four fact tables and all having different keys and columns. I want to make all four fact tables as single fact table as to achieve star model.

       

      Here which method I have to choose.

      Is concatenating all four fact tables or by using link table.

       

      Please guide me on this issue.

       

      Regards,

      Kumar