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.