Null Handling

jpraveen · Post by **jpraveen** » Fri Feb 11, 2011 5:25 am

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...

dr.murthy · Post by **dr.murthy** » Fri Feb 11, 2011 6:19 am

Use Null handling functions , Specify any default value if its nulll

chulett · Post by **chulett** » Fri Feb 11, 2011 7:07 am

An exact search for "Exporting nullable field without null handling properties" would help as well.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 11, 2011 1:49 pm

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.