Lookup_192,1: Failed a keylookup for record.

[rajpatel]

HI,
I am getting follwoing error while running my PX job in DS
"Lookup_192,1: Failed a keylookup for record."
"Operator's runLocally() failed"
Here is what I have,

1) Data_set --> Modify(to take care Null fields which is in look
up)-->trn-->lookup

2) ORA -->TRN -->Lookup (same as #1 lookup)

look up with dist,prod_nbr and prch_num

sometime getting null as prch_num from dataset so, used modify stage to take care

getting above mention error

Please help me

--raj

[sun rays]

HI,
I am getting follwoing error while running my PX job in DS
"Lookup_192,1: Failed a keylookup for record."
"Operator's runLocally() failed"
Here is what I have,

--raj

Try "continue" option if the look-up failed and handle it later-on (probably flag the record as error and populate in a error table or what ever needs to be done).

[rajpatel]

thanks !
Got it