I am using oracle connector stage in datastage 8.1 as reference data for lookup
But i have to use lookup type as sparse
but i am not geting any option to define lookup type in oracle connector
I can find this in oracle enterprise but not in oracle connector
Please suggest
oracle connector stage in datastage 8.1
Moderators: chulett, rschirm, roy
oracle connector stage in datastage 8.1
Sneha!!!!!
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Are you sure you are linking the Oracle connector directly to the lookup and there is no copy stage between the connector and the lookup?
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
The sparse lookup option will be available to you in the Oracle connector stage only if the connector is directly used as a reference link to the lookup stage. There SHOULD NOT be any intermediate stages between the two else you will not find the sparse lookup option.
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
And like you can see in the above diagram, the link on which you define the type of lookup is a reference link!
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.