topic how to join multiple dimension table to single fact table in QlikView

how to join multiple dimension table to single fact table

vipingarg23 — Tue, 21 Nov 2017 09:19:51 GMT

Hi Team,

I have one fact table which is having 36 crore records, and have 4 dimension tables. I need to do inner join 4 dimension table to one fact table. As fact table is having 36cr record, it is taking too much time for below code:

Fact:

Inner Join(Fact)

DimensionA

Inner Join(Fact)

DimensionB

Inner Join(Fact)

DimensionC

Inner Join(Fact)

DimensionD

Can anyone correct me on the same?

Re: how to join multiple dimension table to single fact table

PrashantSangle — Tue, 21 Nov 2017 09:24:57 GMT

your code is correct.

but is it necessary to do inner join dimension table to fact table??? you can keep it on association.

if it is necessary to join then take only required field from dimension table because high number of columns will impact on you script load.

Regards,

Re: how to join multiple dimension table to single fact table

vipingarg23 — Tue, 21 Nov 2017 09:34:20 GMT

Thanks Prashant For your suggestion..