Multiple rows from oracle OCI
Posted: 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
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