0 Replies Latest reply: Nov 29, 2013 3:47 PM by Thomas Jensen RSS

    Different factloads - concat or make view?

      Hello guys,

       

      Whats your view on best practice regarding loading in different facttables?

       

      Eg.

       

      Fact1

      Date

      Amount

      ProductKey

      SalesKey

      ShipKey

       

      Fact2:

      Date

      UserKey

      Amount

      Sales

      Budget

      ProductKey

       

       

      What would you do? Would you make this concatenated or would you make a view where you union these two?

       

      I can come up with some advantages for both - What about you?

       

      I tend to make view, so as much logic as possible is kept in my DW and not in Qlikview. and i avoid syntheic keys easily.