Page 1 of 1

Null Handling

Posted: Fri Feb 11, 2011 5:25 am
by jpraveen
Hi,

I am using sequential file as target and i am getting the error in runtime.

Error:
Sequential_File_52: When checking operator: When validating export schema: At field "PRODUCT_E_DESC": Exporting nullable field without null handling properties.

While i am loading into to file, i am getting this error, Please provide solution for this...

Posted: Fri Feb 11, 2011 6:19 am
by dr.murthy
Use Null handling functions , Specify any default value if its nulll

Posted: Fri Feb 11, 2011 7:07 am
by chulett
An exact search for "Exporting nullable field without null handling properties" would help as well.

Posted: Fri Feb 11, 2011 1:49 pm
by ray.wurlod
You can specify a global Null Field Value on the Format tab of the stage but may need to override this for particular columns by editing their extended properties.