Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
Whats your view on best practice regarding loading in different facttables?
Eg.
Fact1
Date
Amount
ProductKey
SalesKey
ShipKey
Fact2:
UserKey
Sales
Budget
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.