DSXchange

We are going to use the ORAOCI bulk load to load the sequencial files. In the file there will be some records to be inserted and some records to be updated. We will provide the flag for insert or update in the input file if needed. My question is: for the ORAOCI stage in the DataStage, is it doing insert only or is it doing upsert? We would like to use the upsert. Is it possible to do upsert with DataStage and how?

Take a look at the stage properties (Write Method of Load property) and/or the script file that is produced.
Details are in the Parallel Job Developer's Guide in Chapter 12.