Warning in Transformer stage.
Posted: Tue Oct 13, 2009 2:34 pm
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.
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.