Use the Selection Policy editor to define a selection policy.
A selection policy determines the entities and attributes
to use in a data management service.
Entities
The Entities area
displays the entities selected for the policy. The selected entities
are listed according to the logical models that contain the entities.
- Start Entity
- Enter a start entity for the policy, or click Browse to
select a start entity. A start entity is the entity from which data
is selected first during processing. Data from related entities is
selected based on relationships with the start entity.
- Add Entity
- Opens the Add Entity wizard, allowing you to add an entity to
the policy.
- Remove
- Removes an entity selected in an entity list. Any related entities
without parents will also be removed.
- Entity list
- Entities selected for the policy are listed according to the source
logical data model. Select an entity to view the attributes in the Entity
Specification area.
- Type
- The entity type according to the start entity. Related indicates
the data in the entity is selected based on a relationship to the
start entity. Reference indicates the entity
is not related to the start entity and all data in the entity will
be selected.
- Name
- The entity name.
- Relationship/Map
- The relationship name or map name associated with the entity.
Entity Specification
The Entity
Specification area lists attributes for an entity selected
in an entity list. Use this area to provide selection criteria for
one or more attributes. Selection criteria determines which rows are
selected from the entity.
- Entity Path
- The path to the selected entity within the Data Design Project.
- Combine all criteria with
- Option for combining criteria for multiple columns:
- AND
- A row must match selection criteria for all attributes.
- OR
- A row must match selection criteria for one attribute.
- Attributes list
- Displays the attributes for an entity selected in an entity list.
- Name
- The attribute name.
- Data Type
- The attribute data type.
- Selection Criteria
- Enter selection criteria to apply to the attribute. Use an appropriate
operator and value or substitution variable specification. Selection
criteria must conform to SQL syntax and include relational or logical
operators. Logical operators and syntax vary among DBMSs. Refer to
the appropriate DBMS documentation for information.
- Selection Criteria Summary
- After you enter selection criteria, a summary of the selection
criteria applied to the attributes is displayed.