Multiple rows from oracle OCI

kksr · Post by **kksr** » Mon Jul 14, 2008 4:33 am

Hi All,

I have data like this,

Soucre Table as

BBI ADD
1 AMP

Lookup data as BID NAME
1 KK
1 SR
1 MM
2 YS
In job source as Oracle OCI Stage and for Lookup also I am using Oracle OCI
I want to retrieve multiple rows from lookup data (my job is loading only one record from lookupdata)
My final target data as below

1 KK AMP
1 SR AMP
1 MM AMP

I know this can be done through ODBC stage. Apart from this is there is any way to retrive multiple records from my lookupdata

ray.wurlod · Post by **ray.wurlod** » Mon Jul 14, 2008 5:19 am

Not using server jobs. Only the ODBC and UniVerse stages support mutiple returns on reference inputs.

However, if you effect the join within Oracle, the result of the join will contain all matches, and these can be fed into your DataStage job through a single OCI stage.

kksr · Post by **kksr** » Mon Jul 14, 2008 5:28 am

Thanks Ray...