7 Replies Latest reply: Nov 18, 2017 6:55 AM by Bill Markham RSS

    How to resolve non existing dimension ?

    Layla Mar

      Hello ,

       

      What is the best way to connect a dimension missing in a table ?

       

      LOAD:

       

      Region

      Year

      Month

      Sales

       

      from Table1

       

      LOAD

      Channel

      City

      Country

      Order

       

      from Table2

       

       

      Requirement is  sum of Orders from Table2 must reflect by Region in Table1.