6 Replies Latest reply: Sep 5, 2014 2:31 PM by kvp kumar RSS

    data modelling problem

    A Harish

      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

       

      ScreenHunter_25 Aug. 24 23.24 - Copy.jpg