6 Replies Latest reply: Mar 22, 2017 5:35 AM by Stefan Wühl RSS

    Joining/Keeping after outer join

    S P

      Hi All,

       

      I have a table say "Test" in which I am outer joining few tables. After that there is another table in which I am using fields from table Test, something like this:

       

      Test:

       

      Load

      ...,

      ...

      Resident A;

       

      Join (Test)

       

      Load

      ...,

      ...

      Resident B;

       

      and so on. After this I am creating another table using fields from Test

       

      Test1:

       

      Load

      Sum(...),

      ...,

      Resident Test

      group by ...;

       

       

      Now the problem is that after Test table has been loaded, It takes a lot of time to load table Test1.

      When I checked in log file i found that after Test is loaded, there is a statment Joining/Keeping and then Test1 starts loading. However, I do not want this table Test1 to be joined to anything. I tried using Noconcatenate also, but i am not able to make it work.

      Anybody has any ideas on this?