Mapping Designer to configure a mapping and describe the data flow between the source and target. You can also configure filter and sort options, advanced source properties
, key range partitioning
, and transformations in the mapping.
To create a mapping, click
Data Integration
New
Mappings
. Select
Mapping
and click
Create
.
Enter a name and description for the mapping, and click
OK
.
You can use alphanumeric characters and underscores (_) in the mapping name.
To configure a source, on the
Transformation
palette, click
Source
.
In the
Properties
panel, on the
General
tab, enter a name and description.
Click the
Source
tab and configure source details.
Specify the source type. You can choose one of the following options:
Select
Single Object
to select a single SAP object.
Select
Multiple Objects
to specify source object, related source object, and configure the relationship between the source objects. You can use custom relationships to join multiple source objects. When you create a custom relationship for SAP Table objects, you can select the type of join and the source fields to use.
Select
Parameter
to configure the source objects in a
mapping
task associated with this mapping.
Click
Query Options
in the
Source
tab to specify any filter and sort options for the SAP object.
Click
Advanced
to specify the advanced source properties.
To add or remove source fields, to update field metadata, or to synchronize fields with the source, click the
Fields
tab.
You can edit the type, precision, and scale in the SAP table source object metadata.
To configure key range partitioning, click the
Partitions
tab.
In the
Partition Key
field, select the required partition key from the list.
In the
Key Ranges
section, click
Add New Key Range
to define the number of partitions and the key ranges based on which the Secure Agent must partition data.
Use a blank value for the start range to indicate the minimum value. Use a blank value for the end range to indicate the maximum value.
To add a transformation, on the
Transformation palette
, click the transformation name. Or, drag the transformation onto the mapping canvas.
On the
General
tab, you can enter a name and description for the transformation.
Draw a link to connect the previous transformation to the transformation.
When you link transformations, the downstream transformation inherits the incoming fields from the previous transformation.
For a Joiner transformation, draw a master link and a detail link.
To preview fields, configure the field rules, or rename fields, click
Incoming Fields
.
Configure additional transformation properties, as needed.
The properties that you configure vary based on the type of transformation you create.
To add another transformation, repeat these steps.
To add a Target transformation, on the
Transformation palette
, click
Target
.
On the
General
tab, you can enter a name and description.
Draw a link to connect the previous transformation to the Target transformation.
Click the
Target
tab and configure target details. If necessary, configure the advanced target properties.
Target details and advanced target properties appear based on the connection type. For more information, see
Transformations
.
To preview fields, configure the field rules, or rename fields, click
Incoming Fields
.
Click
Field Mapping
and map the fields that you want to write to the target.
To add another Target transformation, repeat these steps.
ASK INFAPreview
