Join Index Checks (PDM)

PowerDesigner provides default model checks to verify the validity of join indexes and bitmap join indexes.

Check

Description and Correction

Name/Code contains terms not in glossary

[if glossary enabled] Names and codes must contain only approved terms drawn from the glossary.
  • Manual correction - Modify the name or code to contain only glossary terms.
  • Automatic correction - None.

Name/Code contains synonyms of glossary terms

[if glossary enabled] Names and codes must not contain synonyms of glossary terms.
  • Manual correction - Modify the name or code to contain only glossary terms.
  • Automatic correction - Replaces synonyms with their associated glossary terms.

Name/Code uniqueness

Object names must be unique in the namespace.
  • Manual correction - Modify the duplicate name or code.
  • Automatic correction - Appends a number to the duplicate name or code.

Existence of base table

Join index must have a base table.

  • Manual correction: Select a base table in the join index property sheet

  • Automatic correction: None

Reference without parent key

Each reference associated with a join index must have a parent key.

  • Manual correction: Set the parent key on the Joins tab of the reference property sheet.

  • Automatic correction: None

Join Index tables owners

The tables associated to a join index must have the same owner.

  • Manual correction: Modify the join index owner or the table owner

  • Automatic correction: None

Join index references connection

Join index references must be connected to selected table on a linear axis.

  • Manual correction: Delete or replace references in the join index

  • Automatic correction: None

Duplicated join indexes

Join indexes cannot have the same set of references.

  • Manual correction: Delete one of the duplicated join indexes

  • Automatic correction: None