Joining/Keeping after outer join

[Anonymous]

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?

[#2]

Test:

Load

...,

...

Resident A;

Join (Test)

Load

...,

...

Resident B;

Drop table A;

Drop table B;

Test1:

Noconcatenate

Load

Sum(...),

...

Resident Test

group by ...;

Drop table Test;

//After Joining Test table it will take little bit more time to create Test1 table...

regards -bika

[#3]

try to use keep

[Anonymous]

I am already using Noconcatenate, is it necessary to drop the tables A & B?

[juleshartley]

I've got exactly this issue - for some reason the log says that a keep/join is happening, when I have not asked one to! No idea why...

[aapurva09]

Another option is to create a new column in the Test1 table as below:

Test1:

Load

Sum(...),

'' AS JUNK

...

Resident Test

group by ...;

Drop table Test;

this will prevent the table to auto concatenate with the tables above. Then you can drop this JUNK column.

Let me know if it works.

[swuehl]

Not sure I understand. You are joining two or more tables before loading Test1, so the log entry is ok for me.

Does it not show up when you remove the script code for Test1?