In this exercise, you will define an executor service to
copy and transform data defined in a source Optim™ logical data model.
To define an executor service to copy and transform data:
- In the Data Source Explorer view, right-click the Services folder
and click . The New Service
wizard opens.
- On the Enter a Service Name and Select a Service Type page,
do the following:
- In Service name, type CustomersMask.
- In the Service Types area, select Copy
service.
- Click Next.
- On the Select a Source Optim Data
Source page, select Optim Sample Database.
Click Next.
- On the Select a Source Logical Data Model page, select OPTIMUSER.ldm.
Click Next.
- On the Select a Data Access Plan page, select Source
Plan. Click Next.
- On the Target Model Options page, select Select
a target model and use an auto mapping of entities. Click Next.
- On the Select a Target Optim Data
Source page, select Optim Sample Database.
Click Next.
- On the Select a Target Optim Logical
Data Model and Operation page, do the following
- From the Target Operation Type area,
select Insert.
- Select the OPTIMUSER2.ldm Optim logical data model.
- Click Next.
- On the Match Schema page, accept the default mapping. Click Next..
- On the Auto Map Results page, review the results of the
auto mapping. Click Finish.
The new data management service, CustomersMask, will appear
under the Services folder. The service will
copy data defined in the source OPTIMUSER Optim logical data model and insert it into
the target defined in the OPTIMUSER2 Optim logical
data model. The service will use the Source Plan data access plan
to determine which data to select and transform from the OPTIMUSER Optim logical data model. The service
definition automatically created a mapping between entities in the
source Optim logical data model
and the target Optim logical
data model.
