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.
From the
New Assets
panel in the
Design
workspace, click
Mapping Specification
.
The
New Mapping Specification
wizard appears.
Enter a unique name and an optional description.
Select the project or folder where you want to create the mapping specification.
Click
Next
.
On the
Sources
panel, click the
Add
icon.
The
Add Source Object
wizard appears.
On the
Source Object
panel, select a source or multiple sources.
Optionally, select a source and click
Data Preview
to preview the source data.
Optionally, select a source and click
Properties
to view the source properties.
Click
OK
, and then click
Next
.
If you selected multiple sources, click the
New Join
icon to create a join and select the edit options to configure the join.
Click
OK
, and then click
Next
.
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.