1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Performance Tuning in Data Integration
  3. Tuning Considerations
  4. Simple Workflow Mode

Simple Workflow Mode

With the Simple Workflow mode, the TDATASEG table is bypassed, and data is loaded directly to the target. This technique eliminates the copy of data to TDATASEG, and also the delete from TDATASEG. The only caveat is that drill-through to the Data Integration landing page is unavailable. (Drill-through using direct drill is available.)

Image shows the Simple Workflow mode option.

Using this simple workflow mode with expressions, the entire load process took 5 minutes and 16 seconds:

Image shows the results using Simple Workflow mode.