DSXchange

Hi
In my parallel job while doing lookup between a dataset and some db2 tabe getting following error

lkp,0: When binding input interface field "XYZ" to field "XYZ": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur;
use a modify operator to specify the value to which the null should be
converted

How to remove this error ? from where this error is coming i.e. from input dataset or referenced lookup db2 tables.?

Look at your design - is XYZ nullable on either of the inputs and not nullable on the output? If your lookup failed rule is Continue, it must be nullable both on the reference input and on the output, because it will be null in the case that the lookup fails.

ray.wurlod wrote:Look at your design - is XYZ nullable on either of the inputs and not nullable on the output? If your lookup failed rule is Continue, it must be nullable both on the reference input and on the output ...

thks