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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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