Working with a selection policy

A selection policy specifies the entities and attributes to use in an Optim™ interoperability model or data management service. A selection policy is defined when you create a data access plan.

Use the selection policy editor to edit a selection policy. The selection policy editor is available in the data access plan editor.

Use selection criteria to filter rows from an entity based on the criteria specified on the attributes. Selection criteria use an SQL select statement to select data from rows in an entity. You can apply selection criteria to an attribute or create an SQL where clause to apply criteria to an entity.

You can also determine which relationships to include in the policy, allowing you to determine the entities that are traversed and the data that is selected.

A selection policy includes the following entity types:

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. When you select a start entity, all related entities are added to the policy.
related entity
A related entity is an entity from which data is selected based on a relationship with the start entity.
reference entity
A reference entity is an entity from which all attributes are selected during processing, regardless of any relationship to a start entity.