Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

0 Replies