DSXchange

Hi,

I like to know if there is a way to drop the record if it comes as NULL from source and we load this record to a column which is defined as mandatory. Currently if the data type is number it loads 0 to that column though it comes as NULL from source.

Appreciate any help on this.

regards,
senthil kumar

Hi

You can try the option like NullToZero(col_name)=0 then Drop the row / what ever you need else xxxx

Hope this might help you.

Cheers
Ram

tsktsk123 wrote:Hi,

I like to know if there is a way to drop the record if it comes as NULL from source and we load this record to a column which is defined as mandatory. Currently if the data type is number it loads 0 to that column though it comes as NULL from source.

Appreciate any help on this.

regards,
senthil kumar

WHY does it "come through as zero"? That is, what configuration of your job specifies that null is to be converted to zero? Hint: look very closely at all the column properties of whatever stage type connects to your source.