You must configure a mapping that contains a Source transformation for a Datacom source and map it to a Target transformation.
To begin creating a mapping in Data Integration, click
New
>
Mappings
>
Mapping
and then click
Create
. In the
New Mapping
dialog box, click
Mapping
>
Continue
.
When you define a Source transformation in a mapping, specify a name for the transformation, a Datacom connection that can connect to the PowerExchange Listener, the source type, and the data map for the Datacom source object. You can also set some additional source properties. The PWX Bulk Metadata Adapter retrieves metadata for the source table from the PowerExchange data map, including the field definitions.
When you define a Target transformation, specify a name for the transformation and a connection to the target. In the user's environment, the target can reside on premises or in a cloud. If you do not want to send all of the incoming fields to the target, you can define one or more exclusion field rules. As part of configuring the target, you must also map the incoming fields to the target fields. You can map fields automatically based on the field names or manually map them.
Instead of selecting specific connections and objects in the Source and Target transformations, you can define a parameter for the connection, the source or target object, or both. You then must enter a specific connection or object in the associated mapping tasks. If you want to use a parameter for the source or target connection, you must perform one of the following actions before the mapping can be successfully validated:
Set the
Source Type
or
Target Type
field to
Parameter
and then enter a parameter for the source or target object in the
Parameter
field. On the
Field Mapping
tab of the Target transformation, you must set the map option to
Automatic
for the mapping to be validated.
If you want to use a specific source or target object with a connection parameter, first select a specific connection, set the
Source Type
or
Target Type
field to
Single Object
, select a source or target object in the
Object
field, validate the mapping, and then enter the connection parameter.
If you want to validate the source-to-target field mappings, map the fields in the Target transformation before validating the mapping. After the mapping is confirmed as valid, enter connection parameters.
You can also completely or partially parameterize field mappings, and then define specific mappings in the mapping tasks.
ASK INFAPreview
