1. Analytical Application Infrastructure User Guide
  2. Data Model Management
  3. Partitioning Support

Partitioning Support

Oracle Partitioning is supported for Model Upload process using erwin. The supported partition types are Range Partitions, List Partitions Hash Partitions, and Interval Partitions.

Note:

  • In the Sliced Model Upload mode, partition information can be added only to the new tables; partitioning an existing table is not supported.
  • By default , the date format for partitions columns of DATE type is set as MM/DD/YYYY and it is seeded in the DMM_PARTITION_DATEFORMAT parameter in the Configuration table. If the date format for DATE partition columns are different in erwin Model, update the parameter value appropriately before performing the Model Upload.
  • Partition information is considered based on the following configuration parameter:

    DMM_MODEL_INCLUDE_PARTITION - Default value is Y.If the value is N, then partition information is skipped during the Model Upload.