1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Performance Tuning in Data Integration
  3. Job Log Analysis
  4. Step 2: Clean up Prior Data Loads

Step 2: Clean up Prior Data Loads

This step is used to clean up data in the TDATASEG_T and AIF_PROCESS_PERIODS tables as shown here:

Image shows cleaning up the TDATASEG_T and AIF_PROCESS_PERIODS tables.

The data in TDATASEG_T is cleared during daily maintenance window. If you are running the process after a restart, this step completes very quickly, but subsequent loads may be slower. In full workflow mode, the data in TDATASEG_T is deleted at the end of the run. In a simple workflow, it is not deleted at the end of the run. If there are more than a million rows from a previous run, then the system performs a batch delete, which is slower than a single deletion.