Changing the Partitioning Key

Procedure

  1. Log in to TIBCO MDM.
  2. Navigate to the Modify Repository screen.
  3. Clear the Partitioning Key check box in the Attribute Details dialog box to remove a previously defined partitioning key.

    If you have already defined a partitioning key and attempt to assign a second attribute (INTEGER type) as a partitioning key, an error message indicating the attribute that is already defined as a partitioning key is displayed and that you will need to undefine it before assigning a new one.

    If the attribute designated as partitioning key is changed, the Database Administrator will have to repartition the tables.

    Note: It is recommended that the partitioning key is not updated often for better efficiency.