A Performance Tuning in Data Integration

Data Integration uses a multi-step workflow to transform and load data into Oracle Enterprise Performance Management Cloud business processes. Each step in the workflow is used to control and manage this process, and each step contributes to the overall performance of the entire process. Within Data Integration, user-selectable options are provided to adjust the workflow and transformation steps to meet customer performance requirements.

At a high level the workflow process is as follows:

Tuning the full process requires the analysis of each step to determine the required level of detail, data volumes, data transformations, and drill-through requirements. These factors drive the options selected and configured in Data Integration to deliver the desired result. The examples in the steps below use the full workflow mode as the workflow type and the load method of "Numeric Data Only."