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
Multiple rows from oracle OCI
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.