Output
Oracle Output
Writes the rows into an existing Oracle table — append, replace, or upsert on key columns — in one transaction, and passes them on.
When to use it
Use it to write results back to an Oracle-based ERP or data mart.
In a pipeline
File InputType ConversionOracle Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Target Table | select | Yes | Select a table |
| Write Mode | select | — | append |
| Key columns | select | — | Columns that identify a row |
Example
Upsert orders
- Target Table=SALES.ORDERS
- Write Mode=Upsert (update rows whose key exists)
- Key columns=ORDER_NO
| ORDER_NO | TOTAL |
|---|---|
| A-1042 | 860 |
| ORDER_NO | TOTAL |
|---|---|
| A-1042 | 860 |
Worth knowing
- Upsert deletes the incoming keys and inserts the rows, inside the same transaction, so a failure changes nothing.
- Booleans are written as 1/0 (Oracle before 23ai has no boolean column type).
- Put a Transaction Control after several outputs to commit them all together.