FULL outer join

uppalapati2003 · Post by **uppalapati2003** » Thu Nov 09, 2006 2:43 am

pradkumar wrote:Thanks for all the suggestions

Hai pradkumar,
merge stasge is there in server we can use this stage also . instead of hash file .(In merge stage they r so many joins are there v can perform it in merge stage.)

clshore · Post by **clshore** » Thu Nov 09, 2006 12:27 pm

Maybe others have had better experience with the Merge stage than I.

I implemented a full outer join with Merge (uggh, what a PITA for lots of columns).

It worked perfectly, but was slow, and metadata changes were awful.

I then used the two Xfm stage method, and got, roghly 5x better performance, and easy maintenance.

YMMV, but I seldom use the Merge stage any more.

Carter Shore

DSguru2B · Post by **DSguru2B** » Thu Nov 09, 2006 1:06 pm

Forget all this duck and goose chase. Just request your dba to create two temp tables, load them with your data and do a database full outer join.

pradkumar · Post by **pradkumar** » Thu Nov 09, 2006 1:58 pm

Hi Carter

I tried outer join in merge, but was not sucesful.
I am using tables as the source. It is giving error as invalid file name

ShaneMuir · Post by **ShaneMuir** » Thu Nov 09, 2006 7:08 pm

pradkumar wrote:Hi Carter

I tried outer join in merge, but was not sucesful.
I am using tables as the source. It is giving error as invalid file name

Pretty sure you have to use sequential files for the Merge stage.

chulett · Post by **chulett** » Thu Nov 09, 2006 7:23 pm

ShaneMuir wrote:Pretty sure you have to use sequential files for the Merge stage.

Yes, you do. That's why it asks for Directory Paths and File Names for the two imputs - what made you think a table name would work there, pradkumar?