Warning in Lookup stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Jay
Participant
Posts: 105
Joined: Tue Nov 11, 2003 8:28 pm

Warning in Lookup stage

Post by Jay »

Hi All,

I am getting the following error

Lkp: When checking operator: Dropping component "LAST_NM" because of prior component with same name

The lookup is being done on 1 key column. But i need to pass the other columns that come in the stream link...

Any ideas as to what could be happening ?

Thanks
Jay
T42
Participant
Posts: 499
Joined: Thu Nov 11, 2004 6:45 pm

Post by T42 »

Both your input and reference link have the same field, and you are not matching that field. Therefore, Lookup stage goes,

"Hmm, something's funny here. This user want to move this field, but I already am moving the same field from input... and this user is not matching the field? Golly, I better let the user know. Maybe he/she forgot to match the field or something."

Remove the field from the reference link if you do not need it.

Rename the field in the reference link (not on the Lookup stage, you're not allowed to do that there, use a transformer or something like that) if you need to move the value from that field along with the input field.

Use a copy stage to remove fields if you are reading directly from a source.
Jay
Participant
Posts: 105
Joined: Tue Nov 11, 2003 8:28 pm

Post by Jay »

Thanks...i'll keep you posted...
Post Reply