Full outer join in server job

[umamahes]

I am reading data using sequentila file and doing look up using hash file as reference.I need matched records and also unmatched from both the input and reference.

How can we do this in server job.Can any one please help me.

[chulett]

You do an "outer join" by not checking the status of the lookup, but that's not a full outer join. For that you'd need to flip the streams and run the data through that way as well, then merge the results.