Null issue in look up

prasadreddyk · Post by **prasadreddyk** » Fri Dec 07, 2007 3:46 am

I am getting a column from source which has a null value....and the same column is being used for look up....so how wud the look stage handle such a situation?the source which i am using is a flat file.

when I am doing lookup,the record which has null value for this coulmn gets rejeted...Is it always the case?

ArndW · Post by **ArndW** » Fri Dec 07, 2007 4:24 am

Null values tend not to come from sequential files, but you can specify your column metadata to get null values. I don't see why a lookup on a null column should be rejected, it is a valid lookup -- unless you have specified that the columns are not nullable in the source or the lookup.

balajisr · Post by **balajisr** » Fri Dec 07, 2007 4:27 am

Are you sure that the lookup stage is rejecting the records? Better if you can post the complete reject message.

ds_sai · Post by **ds_sai** » Fri Dec 07, 2007 8:26 am

hi,
Look upstage will not reject any rows(even null values also),please check whether you specified the meta data correctly or not.

Cheers
ds_sai