When you want to read data from CSV files or search objects in Box, you can specify a Box connection in the Source transformation.
1. To create a mapping, 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 a Box source, on the Transformation palette, click Source.
4. In the Properties panel, on the General tab, enter a name and description.
5. To configure a source, on the Transformation palette, click Source.
6. In the Properties panel, on the General tab, enter a name and description.
7. Click the Source tab and configure source details.
8. Specify the source type as a Single Object.
9. You can choose one of the following options:
- - Enter the name of the CSV file in Box from which you want to read data.
- - Enter Entities to search Box objects based on the URI request parameters you specified in the Box connection.
10. Click Advanced to specify the advanced source properties.
11. To add a transformation, on the Transformation palette, click the transformation name. Or, drag the transformation onto the mapping canvas.
- a. On the General tab, you can enter a name and description for the transformation.
- 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.
- c. To preview fields, configure the field rules, or rename fields, click Incoming Fields.
- d. Configure additional transformation properties, as needed.
The properties that you configure depend on the type of transformation you create. For more information, see the Informatica Cloud Transformation Guide.
- e. To add another transformation, repeat these steps.
12. To add a Target transformation, on the Transformation palette, click Target.
- a. On the General tab, you can enter a name and description.
- b. Draw a link to connect the previous transformation to the Target transformation.
- 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.
- d. To preview fields, configure the field rules, or rename fields, click Incoming Fields.
- e. Click Field Mapping and map the fields that you want to write to the target.
- f. To add another Target transformation, repeat these steps.
13. Save and run the mapping or save and create a Mapping Configuration task.