Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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.