Null handling issue

verify · Post by **verify** » Thu Jan 15, 2009 7:34 am

Hi,

I have source as database where the columns are not nullable.This i need to map to nullable columns.The job got executed with warnings as converting non nullable to null,even after using modify stage.
Can some one please help it out.

Thanks in Advance.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 15, 2009 1:19 pm

Have you a NOWARN specification in your Modify stage?

Are you specifically handling null from input, even though you know it will never occur?

verify · Post by **verify** » Thu Jan 15, 2009 11:01 pm

Yes Ray you're absolutely correct, "I'm handling null from input eventhough it never occurs".
The requirement is to map the input(non-nullable) column to the same output(nullable) column.My job was finished with warnings as "converting non-nullable to null".
I want to avoid this warnings.

How to put "NOWARN" specification in modify stage?
Could you please tell me the syntax?

Thanks..

ray.wurlod · Post by **ray.wurlod** » Fri Jan 16, 2009 1:05 am

It's a separate Specification containing the single word NOWARN