Default to Zero after lookup for Null feilds

[sainath]

Hi

I am just doing a normal lookup from data set file..

I noticed that data stage is inserting Zero value for null fields after lookup. I saw the value in peek stage and datatype is Integer ,,,


I just want to confirm is this is true,,,

please confim


thks

[ray.wurlod]

True? We can only choose to believe what you told us.

Check your job log for warnings, and check null field value in the target stage. Check, too, that the output column is marked as nullable.

[suse_dk]

If you want a null value from your lookup operation the field needs to be nullable on both the input and output side - otherwise it will default to 0 for a integer