Page 1 of 1
Lookup Stage
Posted: Mon Oct 04, 2004 8:40 pm
by waitnsee
I have 2 fields which I am passing to the lookup stage as a reference from the Oracle Database. One of the fields of the two which is a key field is generated by the system. I am getting a NULL VALUE FOUND error on that field, which is very unfair. Its a sequence number which is generated by the system and there is no way of finding a NULL.
Can anyone of you explain me how to rectify that.
Thank you.
Re: Lookup Stage
Posted: Tue Oct 05, 2004 4:20 pm
by pavankvk
can you post the error message??
waitnsee wrote:I have 2 fields which I am passing to the lookup stage as a reference from the Oracle Database. One of the fields of the two which is a key field is generated by the system. I am getting a NULL VALUE FOUND error on that field, which is very unfair. Its a sequence number which is generated by the system and there is no way of finding a NULL.
Can anyone of you explain me how to rectify that.
Thank you.
Posted: Wed Oct 06, 2004 11:15 am
by kjanes
I didn't get a good feel for what your scenario is. Are the key columns for your source and lookup "nullable=no" before, during, and after the lookup?