I too tried tat...but all in vain. For the unmatched records, null is not coming. i dono whether it is blank space.
iam worried what is happening there??
Search found 3 matches
- Fri Jan 04, 2008 12:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LookUp Problem
- Replies: 7
- Views: 2451
- Fri Jan 04, 2008 12:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LookUp Problem
- Replies: 7
- Views: 2451
- Fri Jan 04, 2008 11:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LookUp Problem
- Replies: 7
- Views: 2451
LookUp Problem
Iam trying to lookup a char(1) column with varchar(30) column. But iam not getting null for not matched record in the lookup. When iam looking the records in the dataset after lookup, iam having a blank field but it is not null. I need null when the column is not matched.Please anyone give me an id...