Error in lookup

[sudhakar_viswa]

Hi,

I am getting the following errors.

Lookup_21,0: Ignoring duplicate entry at table record 2; no further warnings will be issued for this table

Lookup_21,1: Failed a keylookup for record.
Lookup_21,1: The runLocally() of the operator failed.

Lookup_21,1: Input 0 consumed 1 records.
Input 1 consumed 1 records.
Input 2 consumed 0 records.

Lookup_21,1: Output 0 produced 0 records.
APT_CombinedOperatorController(1),1: The runLocally() of the operator failed.
Lookup_21,0: Failed a keylookup for record.
Lookup_21,0: The runLocally() of the operator failed.

Lookup_21,0: Input 0 consumed 2 records.
Input 1 consumed 1 records.
Input 2 consumed 0 records.
Lookup_21,0: Output 0 produced 1 records.

Give me a solution for the above errors.

Thanks,
sudhakar

[ArndW]

Sudhakar,

The error message

Lookup_21,1: Failed a keylookup for record.

should mean something to you. This is not a DataStage problem but a data problem. Either add the key to your lookup or change your logic for failed lookups.

[kumar_s]

Also the first warning tells you that the key value in the lookup data has duplicates. Either remove duplicate or handle the duplicate with the option avaialbe in Lookup.
For the second error, check with the "Condiiton not met" and "Lookup failure" options aviable in lookup stage.

[sudhakar_viswa]

Hi Kumar/Arndw,

Thanks.I got it

--sudhakar