6 Replies Latest reply: Dec 5, 2012 10:28 AM by 809759 RSS

    need help on Joins

      I am using 11g.

      Here i am mentioning only the table names which i am facing the problem. It has so many Dim tables.

      Ship - Fact table
      Header - Dim table
      Line - Dim table

      This is one of the part in my Schema. I have joined the dim tables to Fact. And here as per my requirement i need to join 2 dimension tables (Header and Line). How can i do this. Please help me.