Page 1 of 1
oracle connector stage in datastage 8.1
Posted: Fri Nov 23, 2012 6:49 am
by sneha123
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
Posted: Mon Nov 26, 2012 12:39 am
by jerome_rajan
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?
Posted: Mon Nov 26, 2012 6:05 am
by sneha123
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
Posted: Mon Nov 26, 2012 6:10 am
by sneha123
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
Posted: Mon Nov 26, 2012 6:33 am
by jerome_rajan
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.
Posted: Mon Nov 26, 2012 6:39 am
by ArndW
Posted: Mon Nov 26, 2012 6:43 am
by jerome_rajan
And like you can see in the above diagram, the link on which you define the type of lookup is a reference link!
Posted: Mon Nov 26, 2012 7:00 am
by sneha123
Thanks guys