DSXchange

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?

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.

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

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