Hi All
Can we use multiple refernce links(From different oracle Odbc stages) to single lookup stage in parallel ?
Thanks
Lookups with Oracle Odbc
Moderators: chulett, rschirm, roy
Re: Lookups with Oracle Odbc
Yes
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
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 .
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 .
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.