Creating a Mapping Specification
Create a mapping specification as a container for the business logic that transforms and moves data from source to target. You can choose to create a mapping specification from the New menu or from the New Assets panel in the Design workspace.
Before you create a mapping specification, verify that the sources you want to use exist in a project.
1. From the New Assets panel in the Design workspace, click Mapping Specification.
The New Mapping Specification wizard appears.
2. Enter a unique name and an optional description.
3. Select the project or folder where you want to create the mapping specification.
4. Click Next.
5. On the Sources panel, click the Add icon.
The Add Source Object wizard appears.
6. On the Source Object panel, select a source or multiple sources.
7. Optionally, select a source and click Data Preview to preview the source data.
8. Optionally, select a source and click Properties to view the source properties.
9. Click OK, and then click Next.
10. If you selected multiple sources, click the New Join icon to create a join and select the edit options to configure the join.
11. Click OK, and then click Next.
12. Choose to use a virtual target or a target from the Target Object panel.
- - Use a virtual target if you do not know the structure of the target data object.
- - Use a target from the Target Object panel if you know the structure of the data object. If you load the mapping specification results to a table, the structure of this target must match the structure of the target table.
13. Optionally, select a target and click Data Preview to preview the target data.
14. Optionally, select a target and click Properties to view the target properties.
15. Click Finish.