oracle connector stage in datastage 8.1

sneha123 · Post by **sneha123** » Fri Nov 23, 2012 6:49 am

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

jerome_rajan · Post by **jerome_rajan** » Mon Nov 26, 2012 12:39 am

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?

sneha123 · Post by **sneha123** » Mon Nov 26, 2012 6:05 am

Even though if i am using copy stage between the oracle connector and lookup stage but where to define the lookup type as sparse
Please suggest

sneha123 · Post by **sneha123** » Mon Nov 26, 2012 6:10 am

Even though if i am using copy stage between the oracle connector and lookup stage but where to define the lookup type as sparse
Please suggest

jerome_rajan · Post by **jerome_rajan** » Mon Nov 26, 2012 6:33 am

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.

ArndW · Post by **ArndW** » Mon Nov 26, 2012 6:39 am

jerome_rajan · Post by **jerome_rajan** » Mon Nov 26, 2012 6:43 am

And like you can see in the above diagram, the link on which you define the type of lookup is a reference link!

sneha123 · Post by **sneha123** » Mon Nov 26, 2012 7:00 am

Thanks guys