DSXchange

I am slightly puzzled with the datastage full outer join. I have Key fields and values. the full outer join drops off common fiels (other than the key fields , or join fields).

Can anyone tell me on what basis it drops the records.

Shouldn't it be the other way i.e. dropping common key fields and retaining other fields from both inputs.

The full outer join will combine table contents, never drop rows. See http://en.wikipedia.org/wiki/Join_(SQL)#Full_outer_join for a good description of the join functionality.

It drops common key fields because they are identically valued and identically named. You can avoid this by using different naming conventions on the two inputs. A Copy stage is the most efficient stage for simply renaming columns.