Null handel

[consulting]

I am getting following warning in the transformer stage before loading into final dataset

xfm_tranformer,0:Field XXX from input dataset '0' is NULL. Record dropped.

and the output datatype is : Varchar2(52)

[wahi80]

First thing this is a common error and you will find enough material on this in dsxchange. Type Null handling in search, and you will get info.

As for the problem, just check if the column which is giving this error is used in any transformation, also use null handling in the stage variables for this column

i.e id isNull(Columnname) Then '' Else Columname, based on your requirement

[consulting]

Thanks WAhi80

[ray.wurlod]

And the resolution was ... ?

[consulting]

hi ray the resolution was fine the problem is i am using the column name in stage variable i didnt handel null there but handled in transformer only