Default Value for Decimal Lookup Output

devidotcom · Post by **devidotcom** » Mon Jun 07, 2010 4:01 am

Hi All,

The output of my lookup stage is Decimal(5) Null. Will DataStage not give output as Null when the lookup fails. It loads 0 instead.

Please confirm.

Thanks

ArndW · Post by **ArndW** » Mon Jun 07, 2010 5:19 am

It will use 0 if the field is non-nullable.

devidotcom · Post by **devidotcom** » Mon Jun 07, 2010 6:10 am

If it is nullable, it loads 0...

Is this right?

ArndW · Post by **ArndW** » Mon Jun 07, 2010 6:32 am

I can't check right now, but on lookups I would think it returns NULL for nullable fields.

anbu · Post by **anbu** » Mon Jun 07, 2010 10:00 am

The value of target field depends on the nullability of reference field in lookup.

If the reference field in lookup is null then you you will get null in target field if there is no match.

If the reference field in lookup is not null then you will get zero in target integer field if there is no match.