Whats your view on best practice regarding loading in different facttables?
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.
Retrieving data ...