Configuring a Mapping with a Single SAP BW Source

1. Click Design > Mappings, and then click New Mapping.
The New Mapping dialog box appears.
2. Enter a name and description for the mapping, and click OK.
You can use alphanumeric characters and underscores (_) in the mapping name.
3. To configure an SAP BW source, on the Transformation palette, click Source.
4. In the Properties panel, on the General tab, enter a name and description for the SAP BW source.
5. Click the Source tab and configure the SAP BW source details.
6. Select an SAP BW Reader connection from the list or click New Connection to create a new SAP BW Reader connection.
You can also parameterize the connection.
7. Specify the source type. You can choose one of the following options:
• - Select Single Object to select a single SAP BW object.
• - Select Parameter to configure the SAP BW source objects in a Mapping Configuration task associated with this mapping.
8. Enter the SAP BW object name or click Select to search for an object based on its name, label, description, or type.
9. Select the SAP BW object from which you want to read data and click OK.
10. Click Query Options in the Source tab to specify data filters for the SAP BW object.
You can specify a simple data filter based on key characteristic fields.
Note: You cannot create an advanced data filter.
1. a. Click Configure and then click the + icon to add a data filter.
2. b. Select the source object, key characteristic source field, and operator.
You can select one of the following operators for the filter condition:
• ▪ Equals
• ▪ Not Equals
• ▪ Less Than
• ▪ Less Than or Equals
• ▪ Greater Than
• ▪ Greater Than or Equals
3. c. Enter the value that you want to use and click OK.
You can also parameterize the filter condition.
11. Click Advanced to specify the advanced source properties.
12. To add or remove source fields, update field metadata, or synchronize fields with the source, click the Fields tab.
13. To add a transformation, on the Transformation palette, click the transformation name. Or, drag the transformation onto the mapping canvas.
1. a. On the General tab, you can enter a name and description for the transformation.
2. b. 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.
3. c. To preview fields, configure the field rules, or rename fields, click Incoming Fields.
4. d. Configure additional transformation properties, as needed.
The properties that you configure vary based on the type of transformation you create.
5. e. To add another transformation, repeat these steps.
14. To add a Target transformation, on the Transformation palette, click Target.
1. a. On the General tab, enter a name and description for the target.
2. b. Draw a link to connect the previous transformation to the Target transformation.
3. c. 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 the Informatica Cloud Transformation Guide.
4. d. To preview fields, configure the field rules, or rename fields, click Incoming Fields.
5. e. Click Field Mapping and map the fields that you want to write to the target.
6. f. To add another Target transformation, repeat these steps.
15. Save the mapping. You can choose one of the following save options:
• - Click Save and Close to save and close the mapping.
• - Click Save and Run to save and run the mapping immediately.
• - Click Save and New Mapping Configuration Task to save and create a Mapping Configuration task.