We are using Data Stage 6.0.1 on Sun Solaris and the Prime Database we connect to is Oracle 9i. All our database operations are performed using the ORAOCI9 plug-in. But just thought of these things,
When I use a Update/Insert strategy in my update action the Plug-in generated a update and an insert script which is the common way of handkling this strategy. But with Oracle 9i in picture this can be achieved by the Merge/Upsert setup Right. If using OraOci9 plug-in doesn't do this the Why OraOci9 ?
See this is one scenario. I would also like to know if the ORAOCI9 os compatible to all the other Oracle 9i features?
Please advice if these are taken care in Datastage 7
![Sad :(](./images/smilies/icon_sad.gif)
Thanks,
Badhri ...
Badhrinath Krishnamoorthy
www.cognizant.com