DSXchange

Hi All

Can we use multiple refernce links(From different oracle Odbc stages) to single lookup stage in parallel ?


Thanks

Yes

Lookup stages support multiple inputs. So you can use the any input stages as reference.

Thanks for your inputs.
But why does the documentation say that during sparse lookups you can have only one ref link .
Does it mean that when you are using oracle or DB2 stages you can use one and only one refernce link (oracle or DB2 stage) ?

Please correct me if I am wrong . It is really confusing .

You did not mention sparse lookups in your original question.

Sparse lookups do have the restriction of one reference input link.

A Lookup stage can support any (reasonable) number of reference input links performing normal lookups, but only one lookup if it is performing a sparse lookup.

A normal lookup is performed against the virtual Data Set associated with the reference input link. A sparse lookup is performed directly against the database table.

Perhaps you can try to acheive the Multiple lookup by converting the sparse lookup into Normal / uploading the Database data into a lookup file set.