Selection Policy editor

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.