Working with a subset service

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.