0 Replies Latest reply: Sep 5, 2014 12:31 PM by A Harish RSS

    data modelling problem

    A Harish

      hi ,


      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,





      ScreenHunter_25 Aug. 24 23.24 - Copy.jpg