need a help/suggestion in using Link Table

[mdmukramali]

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.

[#2]

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.

[mdmukramali]

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

[#4]

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.