I am having some problem with my lookup.I am having 459 rows in the source table and 145 rows in the lookup table(Key is unique in the lookup table).But when i am doing the lookup with this unique key i am able to fetch only 68 rows whereas my output should have 459 rows.When i checked it in director log it is giving me following errors
lkp_group,0: Failed a keylookup for record.
lkp_group,0: The runLocally() of the operator failed.
APT_CombinedOperatorController(0),0: The runLocally() of the operator failed.
APT_CombinedOperatorController(0),0: Operator terminated abnormally: runLocally did not return APT_StatusOk
I dont understand what i am missing there itried to trim the keys also but still i am having the same problem.
Do you have all the 459 key match in the lookup data with in 145?
What is the condition given, if lookup failed, is it fail or reject or continue?
Have a reject file and mark it as reject and try to collect all the unmatch records in a seperate file and to a verification.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Could be worth disabling combination to be certain, but I feel that your "failed lookup" rule is Fail.
If the data type is string, make sure that there is no extraneous white space in the lookup data (key) or in the stream data (lookup value).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod wrote:Could be worth disabling combination to be certain, but I feel that your "failed lookup" rule is Fail.
If the data type is string, make sure that there is no extraneous white space in the lookup data ...
Hi ray
The data type is 'char'.Thinking that there might be some white space i tried to trim the key field.But still same problem.
I doubt that Trim() will help; a Char(n) - or string[n] - must always be n characters long. You need to ensure that all n match for the lookup to succeed. Or convert to VarChar(n) - or string[max=n].
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod wrote:I doubt that Trim() will help; a Char(n) - or string[n] - must always be n characters long. You need to ensure that all n match for the lookup to succeed. Or convert to VarChar(n) - or string[max=n] ...
The problem has been solved.As Ray mentioned i tried it and it is fixed.