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