A subset service copies data from one logical data model
to another logical data model. Using the selection policy defined
in the data access plan of a source logical data model, you can create
a subset of the source data that is copied to the target model. You
can use a privacy policy in a subset service.
Use the New Service wizard to create a subset service. You must
select a source logical data model and a data access plan in the model.
You must also select target model options.
Target Model Options
Use the Target Model
Options page in the New Service wizard to determine how to select
a target data model for the service as well as the type of operation
to perform on the target data model.
The following target model
selection options are available:
- Select a target model and perform auto map
- Use this option to select a target logical data model and allow
the Designer to automap the source and target model. The automap function
maps entities and attributes in the source model to matching entities
and attributes in the target model. For the automap function to work,
the source and target models should have similar schemas.
- Create an Optim™ managed
data store model based upon the source model
Use this option to create a target logical data model that
represents a managed data store. When you select this option, the Optim
managed data store model field will be displayed, allowing
you to enter a name for the new logical data model.
The target
model will include a schema that matches the source model. After the
service populates the data store, you can use the associated logical
data model as a source model in a service.
- Open the service plan editor and manually complete the target
model selection and map the source to the target
- Use this option to open the service plan editor, in which you
will select a target model and map the source model to the target
model.
The following target operations are available:
- Insert
- Inserts new rows into the destination entities. If the primary
key of a row in the source data does not match the primary key of
a row in the destination entity, the row is inserted. If the primary
key of a row in the source data matches the primary key of a row in
the destination entity, the operation fails.
- Update
- Updates existing rows in the destination entities. If the primary
key of a row in the source data matches the primary key of a row in
the destination entity, the row is updated. If the primary key of
a row in the source data does not match the primary key of a row in
the destination entity, the operation fails.