DSXchange

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

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.

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