Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.

Tags (3)
Community Browser