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

Partitioning Support

Model Upload Process is supported by Oracle Partitioning using erwin.

erwin supports Range Partitions, List Partitions, Hash Partitions, and Interval Partitions.

Note:

  • In the Sliced Model Upload mode, you can add the partition information only to the new tables; partitioning an existing table is not supported.
  • By default, date format for the partitions columns of type DATE 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 the erwin Model, then 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.

Registering Partition Information

You can register the partition information during the Model Upload Process. Partition information for tables is retrieved and registered into the OFSAAI object registration table REV_TAB_PARTITIONS during the Model Upload Process.

Partition table name and column names are added to V_TABLE_NAME and V_COLUMN_NAME, respectively, in the REV_TAB_PARTITIONS table. Partition Sequence is stored in N_PARTITION_SEQUENCE. The sequence starts from 1 for the major partition column and the maximum sequence number is equal to the number of partitioned columns. V_PARTITION_VALUE holds the value for a particular partition to be considered for any executions. Data into this column can be populated manually or with the help of any OFSAAI table data load options.

Hive supports static and dynamic partitions. Values for static partition are known in the query whereas dynamic partition values are known at the execution time. If V_PARTITION_VALUE is null in REV_TAB_PARTITIONS, the table is considered as dynamic partitioned. AAI Executions run on Static and Dynamic Partitions.

Sub Partitioning Support

Sub Partitions of type Range-Hash, List-Hash, and Interval-Hash are supported for the Model Upload Process using erwin.