data modelling problem

[munna1317]

hi ,

as shown in the below image ,

i have one task details as " transaction table (Fact-Table)"

and

i have remain all are "master- table(Dimension-table)"

- Calender2 is a master caleder is just link to fact table with "link- date ".

1st problem :

i am getting only the transaction table details which are common to corresponding dimensions.

2nd problem :

i need to link master calender"linkdate" to all dimension with out generating any syntactic keys or circular reference .

plz tell solution ,

thnks in adv,

harish

[ecolomer]

Can you revise your information because you speak about fields non exist in the graphic

[munna1317]

hi ,

Plz check the details

Task_details is transaction table(facttable)

remin all dimesion tabls

And Link date is an dimension that is connected to Task_details

thxs ,

harish

[#4]

If you need to connect your Date Dimension (Master Calendar), you are going to have to use a Link Table.

[munna1317]

ya thxs robert ,

plz tell how to create a link table for above image just give sample sytax and model

regrds,

Harish

[ashfaq_haseeb]

Hi,

have a look at below post

data modelling problem

Regards

ASHFAQ

[kumarkp412]

hi,

By using the link table, we can acess the master calendar.To create the link table

eg:

I cant understand the ur model,

I can not see in your sample if you have the field name in two tabels. If you dont you can not use it in your Linktable

link table:

load distinct

key(ie.common key between two tables)

resident calendar2;

concatenate

load distinct

key(ie.common key between two tables)

resident calendar1;

and if u want to remove the synthatic keys &circular referrence ,by renameing the feilds .