DSXchange

Posted: **Wed May 18, 2011 7:58 pm**

Hi,
For datatype smallint i am doing '' in transformer but it is giving me 0 as output how can i pass null instead of 0

Thanks

Posted: **Wed May 18, 2011 8:25 pm**

INT Data type will treat it as 0.

Posted: **Wed May 18, 2011 8:29 pm**

Have you tried the setNull() function?

Posted: **Wed May 18, 2011 9:07 pm**

'' != null

Posted: **Wed May 18, 2011 9:24 pm**

The output column must be marked as Nullable, otherwise a default value will be substituted.

smallint not passing null value