topic Re: need a help/suggestion in using Link Table in QlikView

need a help/suggestion in using Link Table

mdmukramali — Tue, 31 Mar 2015 06:19:16 GMT

Dear All,

I have a scenario .

i have 6 Fact Tables and common key between the tables are RequestNo and RequestYear. (RequestNo &'_'& RequestYear)

and each table contain date field (Not common ) so in this scenario can i use the Link table concept.

so i thinking whether link table will be helpful or not ?

so please can anyone suggest me in my scenario link table will be helpful or not ?

Thanks,

Mukram.

Re: need a help/suggestion in using Link Table

Tue, 31 Mar 2015 06:26:11 GMT

Hard to tell without further knowledge of the data and tables you use. I never used a linktable with more than 3 fact tables so far.

Could you probably provide a demo application ?

Depending on the data you should also consider to concatenate all of your fact tables. That way it is often easier to link the dimension tables and could possibly be more performant too.

Re: need a help/suggestion in using Link Table

mdmukramali — Tue, 31 Mar 2015 06:40:33 GMT

Thanks.

i cant concatenate all the 6 tables because each table contain many fields. ( records also more ) .

only 2 fields are common between them.

so still i am in confusion, whether to use link table are not for common calender ?

Any suggestions please.

Thanks,

Mukram

Re: need a help/suggestion in using Link Table

Tue, 31 Mar 2015 07:32:07 GMT

Then I would say creating the linktable is your best bet.

Just create a table with a key column to your calendar and one key for each fact and make sure the fact tables dont share a same name columns so you dont get any circular references.

Fact1:

Load RequestNo &'_'& RequestYear as Fact1Key,

from Fact1.qvd

LinkTable:

Load

distinct Fact1Key,

CalendarDate

Resident Fact1

Concatenate

Load

distinct Fact2Key,

CalendarDate

Resident Fact2

etc.