DSXchange

Hi,

I am trying to do a lookup using a hash file..
I have ColA in seq file and ColA in Hash file(both files same structures)...I wanted to know how can I get a ColA data from hashfile if there is no match found in seq file but we have in hash file...(basically a outer Join)..
I tried to use merge stage, but having problems with It..Warning !!! "Construct Hash file failed"

Thanks

Hi,
For this You can not create a hash file as a driving file to bring all records(i.e.Outer join).You need to do this in 2 pass,first create a hash file from sequential file and then this newly created hash file can be used as a driving file.

Regards,
Narendra

In the contratint you have to write that wherever the HashFile(ColA) <> SeqFile(ColA). And u will get all the rows from Hash file which are not present in the Sequential File.

How can I do a full outer join using Hash. I need to get the ColA value if it is present either in the driving file or the look-up file.

-Thanks

Not possible using a Hashed File stage. This uses the primary key, the whole primary key, and nothing but the primary key.

How would you do it if one table were Oracle and the other DB2? You can do the same with anything and a hashed file, if you access the hashed file via a UV stage.