full outer join (returning defaults)

[Barath]

Hi,

I am using FullOuterJoin in my job. All its inputs from start of the stream (this is the first job in the stream) have been kept as nullable (Yes). When I try to join based on Key fields say KeyField_1, KeyField_2. I am getting default values instead of nulls when no match is found.

I managed to implement it once to obtain nulls if match is not found instead of default values. But not able to recollect how to do it. Can anyone help.

Thanks

This we can debug this in two ways
1. before join stage write those data into one file check the junk values are coming or not. Because while unloading the from teradata database it may generates sometime junk values. Thiose we need to avoid using Translate_CHK function.
2. If the junk values are getting gnerated after join stage........
We also raised a patch to IBM.

CHeck it get back to me on barath.teradata@gmail.com