Reject record with NULL from src loads to a mandatory column

[tsktsk123]

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

[SURA]

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

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

[ray.wurlod]

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.