Rows being rejected

[DS110]

Hi,

In our one datastage job fews rows are being rejected from the Transformer stage into a reject link and following is the error.

CCD_Xfm,1: Field 'FMLY_ID' from input dataset '0' is NULL. Record sent to reject dataset.

We tried replicating the same in another job but in that jon rows not are being rejected even source column haing NULL value.

Please help

[Sainath.Srinivasan]

Maybe NULL values are allowed in this case. Is the target a nullable column ?

Also check the datatypes. It is possible that datatype conversion may result in NULL.

[kris007]

This typically happens when Null handling is not done on the derivations within the Transformer stage that have some kind of transform logic built into it and the source value is NULL. For Example, if your derivation is something like

Code: Select all

Trim(field1)

and if field1 has NULL values, you will have rejected rows.

[srinivas.g]

Use the nulltoempty function