Null value appeared as '0' for integer column
Posted: Tue Nov 09, 2010 5:53 pm
Hi,
I created a simple job where I have two sources (defined as sequential file stages), a Join stage ( doing Outer joins) and then loading the final output to a sequential file stage.
Everything works fine. As I am using outer joins I am expecting null values. There is a record where null values should be appeared.
For Varchar fields the null value is appeared as blank. But the null value for Integer variable is appeared as '0' in the file.
Not sure why its coming like this. I am using all default settings for sequential file stage.
Please help me in this.
I created a simple job where I have two sources (defined as sequential file stages), a Join stage ( doing Outer joins) and then loading the final output to a sequential file stage.
Everything works fine. As I am using outer joins I am expecting null values. There is a record where null values should be appeared.
For Varchar fields the null value is appeared as blank. But the null value for Integer variable is appeared as '0' in the file.
Not sure why its coming like this. I am using all default settings for sequential file stage.
Please help me in this.