topic Different factloads - concat or make view? in QlikView https://community.qlik.com/t5/QlikView/Different-factloads-concat-or-make-view/m-p/510872#M687437 <HTML><HEAD></HEAD><BODY><P>Hello guys,</P><P></P><P>Whats your view on best practice regarding loading in different facttables?</P><P></P><P>Eg.</P><P></P><P>Fact1</P><P>Date</P><P>Amount</P><P>ProductKey</P><P>SalesKey</P><P>ShipKey</P><P></P><P>Fact2:</P><P>Date</P><P>UserKey</P><P>Amount</P><P>Sales</P><P>Budget</P><P>ProductKey</P><P></P><P></P><P>What would you do? Would you make this concatenated or would you make a view where you union these two?</P><P></P><P>I can come up with some advantages for both - What about you?</P><P></P><P>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.</P></BODY></HTML> Fri, 29 Nov 2013 20:47:57 GMT 2013-11-29T20:47:57Z Different factloads - concat or make view? https://community.qlik.com/t5/QlikView/Different-factloads-concat-or-make-view/m-p/510872#M687437 <HTML><HEAD></HEAD><BODY><P>Hello guys,</P><P></P><P>Whats your view on best practice regarding loading in different facttables?</P><P></P><P>Eg.</P><P></P><P>Fact1</P><P>Date</P><P>Amount</P><P>ProductKey</P><P>SalesKey</P><P>ShipKey</P><P></P><P>Fact2:</P><P>Date</P><P>UserKey</P><P>Amount</P><P>Sales</P><P>Budget</P><P>ProductKey</P><P></P><P></P><P>What would you do? Would you make this concatenated or would you make a view where you union these two?</P><P></P><P>I can come up with some advantages for both - What about you?</P><P></P><P>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.</P></BODY></HTML> Fri, 29 Nov 2013 20:47:57 GMT https://community.qlik.com/t5/QlikView/Different-factloads-concat-or-make-view/m-p/510872#M687437 2013-11-29T20:47:57Z