NullToEmpty - Exporting nullable field without null handling

Apotluri · Post by **Apotluri** » Wed Jul 16, 2008 9:31 am

Hi, I am wrting to a sequential file and I have a column name A - varchar(25) and it is nullable, in the transformer I have used NullToEmpty and I am still getting a warning - Exporting nullable field without null handling properties.

Please help me remove these warnings.

Thanks, as always

abc123 · Post by **abc123** » Wed Jul 16, 2008 9:55 am

I am assuming that this is your job design, at least part of it:

SeqFile --> Xfm

You have to have it nullable in the SeqFile stage and Not Nullable on the output of the transformer.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 16, 2008 4:09 pm

Just to keep it happy set the Null Field Value property for this field to "" (indeed, having done so, you could remove the NullToEmpty transformation).

MaliniLakhani · Post by **MaliniLakhani** » Tue Apr 01, 2014 11:14 pm

Thanks, that did the trick for me.

thompsonp · Post by **thompsonp** » Wed Apr 02, 2014 3:38 am

In the transformer output link have you changed the column from nullable to not nullable in keeping with the NullToEmpty transform?