DSXchange

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.

Have you a NOWARN specification in your Modify stage?

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

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

It's a separate Specification containing the single word NOWARN