Warning in Transformer stage.

[kollurianu]

Hi All ,

I am getting following warning in the transformer stage after I add the following constraint (DSLink77.TIN_NUMBERS) <> ""
Where Filter2 is the Transformer stage.

Filter2,1: Field 'TIN_NUMBERS' from input dataset '0' is NULL. Record dropped.

Filter2,2: Field 'TIN_NUMBERS' from input dataset '0' is NULL. Record dropped.

I searched for the related posts , but didnot help much .

null_field = "" in the field properties for all the fields in all the stages in the job.

If I take out the constraint then it is not giving these warnings.

Any Thoughts , greatly appreciated.

[divesh]

Do the NULL validation for DSLink77.TIN_NUMBERS before using it in the constraint

[atulgoel]

Hi,

Please use the NUll validation function in the transformer for the required columns.

NullToEmpty(column_name)


Atul