Partitioning Tables

A table partitioning option is available when loading large volumes of data. This feature is first used if a sudden performance degradation of your integrations has occurred. Table partitioning provides enhanced support for large data loads to the TDATASEG_T and TDATASEG tables by letting you decompose them into smaller, independent and more manageable pieces. Each data load works on a separate petition on which supports parallel processing. Additionally, a partition can be truncated instead of deleted from the from the TDATASEG_T table, which enhances performance.

In general, table partitioning is a technique used by database administrators to help manage performance of customer datasets. For Oracle Fusion Cloud Enterprise Performance Management, customers don’t have direct access to the database, this feature has been enabled within Cloud EPM to allow users to directly perform this operation, but not as a direct user command against the database. Using this feature improves overall data load performance when a large number of mapping rules are used to transform the data prior to loading to the downstream business processes.

Run the Partition Data Load Staging Tables process only when no data load processes are running.

To enable table partitioning, see Partition Data Load Staging Tables.