The following table directs you to the PI table explanation that contains SQL for each Analysis task listed:
|
If You Want To |
See |
|---|---|
|
Find the attributes of an entity type or subtype |
ATTRIBUTE |
|
Find the classifying attribute of a partitioning |
PARTITIONING/CLASSIFIER |
|
Find the identifying attribute(s) of an entity type |
ATTR_IDENT or IDENTIFIER |
|
Find the entity types in a model |
ENTITY_TYPE |
|
Find the relationships between entity types |
RELATIONSHIP |
|
Find the identifying relationship of an entity type |
REL_IDENT or IDENTIFIER |
|
Find the mutually exclusive relationships of an entity type |
REL_MUTL_EXCL |
|
Find the permitted values of an attribute |
PERMIT_VALUE |
|
Select entity types, classifying attributes, and subtypes |
PARTITIONING/CLASSIFIER |
|
Select the mutually exclusive relationships from each of the entity types in a model |
REL_MUTL_EXCL |
|
Select the root subject area in a model |
SUBJECT_AREA |
|
Select the subject areas and their parent subject areas |
SUBJECT_AREA |
|
Select the entity types in a subject area |
ENTITY_TYPE |
|
Select the attributes with default permitted values |
ATTRIBUTE |
|
Select the derived attributes for a derivation algorithm |
ATTRIBUTE |
|
Select the permitted value ranges for an attribute |
PERMIT_VALUE |
|
Select the classifying value for a subtype |
ENTITY_SUBTYPE |
|
Copyright © 2013 CA.
All rights reserved.
|
|