2 Replies Latest reply on Nov 22, 2016 1:17 PM by Homer Roderick

    Data Model

    Govind Ramchetty

      HI

      I have 2 fact tables and 10 dim tables .

       

      E.g

      Fact1

      DateID

      INV_ID

      ....

       

      Fact2

      DateID

      INV_ID

      .....

       

      Date_DIM

      DateID

      .....

       

      INV_DIM

      INV_ID

       

      Above tables when i joined it taking into loops.How we can join 2 fact tables and multiple dimension .

      Thanks

      Govind R