Page 2 of 2
Posted: Thu Nov 09, 2006 2:43 am
by uppalapati2003
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.)
Posted: Thu Nov 09, 2006 12:27 pm
by clshore
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
Posted: Thu Nov 09, 2006 1:06 pm
by DSguru2B
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.
Posted: Thu Nov 09, 2006 1:58 pm
by pradkumar
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
Posted: Thu Nov 09, 2006 7:08 pm
by ShaneMuir
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.
Posted: Thu Nov 09, 2006 7:23 pm
by chulett
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?
