DSXchange

Hi,
In a parallel job, a lookup stage is using a Sybase table as a reference link, it's a sparse lookup. This job is aborting with following error - "putRecord() called on output port 0 multiple times per activation of the processing logic of the operator."

Can anybody knows about this error?

Thanks,
Sreeni.

Welcome aboard.

Have you enabled the option in the Lookup stage that allows multiple rows to be returned from the reference input link?

You are right, but when i use Sparse Lookup it is not showing the input link in the "Multiple rows to be returned from the reference input link".

Thanks
Sreeni.

My bad. I didn't notice you're doing a sparse lookup. A sparse lookup expects no duplicates - it expects that you're doing a lookup on the primary key (or some other column supported by a unique index).

Thanks Ray