Mapping Specification Target
Use a target in the mapping specification to define the structure of the target data object.
You must know the structure of the target data object if you use a target in the mapping specification. If you do not know the target structure, you can choose a virtual target. The Analyst tool creates an empty target in the mapping specification. You can edit the mapping specification to configure the target.
After you finalize the mapping specification, you can load the mapping specification results to a target data object that matches the structure of the target in the mapping specification.
Note: The structure of the target columns in the mapping specification must match the structure of the columns in the target table data object.
Mapping Specification Target Datatypes
If the target contains incompatible datatypes, you cannot load the results of the mapping specification to a target or export the mapping specification logic to PowerCenter.
The following datatypes are compatible with the mapping specification target:
- •Integer
- •Bigint
- •String
- •Text
- •Binary
- •Decimal
- •Double
- •Datetime
Edit Options for Targets
When you edit the target in a mapping specification, you can select an edit option to edit it.
You can edit the target from the Transformations and Target Columns panel and select an edit target option to perform an edit task. You can select the edit options for the target on the Target tab of the Edit Mapping Specification window. You can also drag multiple source columns from the Sources panel to add to the target in the Transformations and Target Columns panel.
You can add a column and select a column to edit it. You can select one or more target columns and duplicate them, or move columns up or down, or delete columns.
After you edit the target, you can preview the data on the Data Preview tab and view the target properties on the Properties tab.
Editing the Target
Edit the target in a mapping specification to add target columns or modify the properties of the target columns.
1. From the Actions menu, click Edit > Target.
The Edit Mapping Specification wizard appears.
2. Select an edit target option to perform an edit task.
3. Optionally, click the Refresh in the Data Preview panel to preview the target data.