Greetings,
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
Thanks,
Badhri ...
Badhrinath Krishnamoorthy
www.cognizant.com
Why ORAOCI 9 ?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Plug-in stages have their own versioning strategy, and do not depend on the DataStage version number. Plug-in stages written correctly according to the API are guaranteed to be forwards compatible. Right now I don't have access to a DataStage machine, perhaps someone with version 7 could post the version number of the ORAOCI9 stage that accompanies it, then Badhri could compare with his. (I don't expect any difference.)
Meanwhile, Badhri, why not post a DataStage enhancement request, either on this forum or via your support provider?
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
Meanwhile, Badhri, why not post a DataStage enhancement request, either on this forum or via your support provider?
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518