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 issue in look up
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 2
- Joined: Thu Mar 29, 2007 12:54 am
- Location: chennai
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>