as shown in the below image ,
i have one task details as " transaction table (Fact-Table)"
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,