0 Replies Latest reply: Aug 25, 2011 8:17 AM by mady mama RSS

    Using Outer Join consumes additional memory when loading?

      Hello Experts,

       

      I have 2 tables Table1 , Table 2  both have yearmonth and Customer fields. But in Table 1 I have a date for customer only when he paid an Amount so its limited, and In Table2 I have each yearmonth for each customer irrespective of their payments.

       

      I am doing something like below:

       

      Table1:

      Load YearMonth,

               Customer,

                Sales

      From XYZ.Table

       

      Table2:

      Outer Join (Table1)

      Load YearMonth,

                Customer

      From ABC.Table

       

       

      But the above gives me Memory Timed out error. When I do a normal Join it looks like it works but I want an Outer Join so that I can have a YearMonth per Customer for an Amount paid and Blank if not.