Hi,
In my job i m using a oracle lookup.
I want keep track of all the recods that is matched by the lookup key and also that doesnot match.
for this i m using the property - linkname.NOTFOUND(or NOT(linkname.NOTFOUND)) at constraint level,but it is not giving the desired result.it is sending all the records to the matched target file.
can anyone tell why is it behaving like this.
OR
if any one has any other solution for how to track the lookup result for matched and unmatched records then please let me know.
how to track the lookup Result that is not matched by lookup
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 37
- Joined: Fri Oct 21, 2005 4:09 am
how to track the lookup Result that is not matched by lookup
Thanks and Regards
Abha
Abha
Instead of linkname.NOTFOUND(or NOT(linkname.NOTFOUND))
use
isNull with all the lookup keys to see if all are null then no match is found otherwise a match is found.
linkname.NOTFOUND manytimes doesn't work correctly with lookup stages other than Hashed File lookups.
use
isNull with all the lookup keys to see if all are null then no match is found otherwise a match is found.
linkname.NOTFOUND manytimes doesn't work correctly with lookup stages other than Hashed File lookups.
Success consists of getting up just one more time than you fall.
Unfortunate but true. It doesn't seem to work at all with the OCI stages, probably because they haven't coded them to support it.loveojha2 wrote:linkname.NOTFOUND manytimes doesn't work correctly with lookup stages other than Hashed File lookups.
![Confused :?](./images/smilies/icon_confused.gif)
The only stage I used the NOTFOUND status with is a hashed file stage, all others IMHO should fall back to the 'old style' check-a-key-field-for-null post lookup technique, the only way you had before they added the NOTFOUND status. You only need to check one, not all, but if there's a key field you know you put something in and now it's null, the lookup failed.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers