In Oracle Integration Cloud (OIC), the Mapper is a critical tool that allows you to transform data between different formats or structures in your integration flows. When you use the Mapper activity, you have several options and features at your disposal to facilitate data transformation. Here are the primary Mapper options in OIC:

1. Data Mapping: The core function of the Mapper is to define data mappings between source and target structures. You can:

• Drag and drop elements from the source structure to the target structure to create mappings.
• Use expression builders to apply functions or operations to the data during mapping.
• Define complex mappings for hierarchical data structures.

2. Expression Builder: Within the Mapper, you can access the Expression Builder, which is a powerful tool for creating custom expressions and transformations. It allows you to:

• Use functions, operators, and constants to build expressions.
• Access predefined functions for common operations, such as string manipulation, mathematical calculations, date formatting, and more.
• Create conditional expressions to control data flow based on conditions.

3. Function Libraries: OIC provides a set of built-in function libraries that you can use in your expressions. These libraries cover a wide range of functions, making it easier to perform complex data transformations.

4. Looping: If you’re working with repeating elements (e.g., arrays or lists), you can use the Mapper’s looping capabilities to iterate through elements and map data accordingly. This is particularly useful for handling repeating data structures.

5. Lookup Functions: OIC allows you to perform lookups within your Mapper. You can use lookup functions to retrieve data from Lookups or other sources and use it in your mapping.

6. Constants: You can define constants within the Mapper, which can be used as fixed values during data mapping. This is helpful when you need to add specific values to your target data.

7. Conditional Mapping: You can create conditional mappings based on specific conditions. For instance, you can map data differently depending on the value of a field in the source data.

8. Testing and Debugging: The Mapper provides testing and debugging capabilities, allowing you to test your data mappings with sample data. This helps ensure that your mappings work correctly before deploying your integration.

9. Auto-Mapping: In some cases, OIC’s Mapper offers auto-mapping functionality, which automatically creates mappings between elements with matching names or types in the source and target structures. While this can speed up mapping, you should still review and adjust mappings as needed.

10. Custom Functions: You can create custom functions in Oracle Integration that can be used within your Mapper. These custom functions can encapsulate complex logic that you want to reuse across multiple mappings.

11. Variables: You can use variables within the Mapper to store and manipulate data during mapping. Variables can be helpful when you need to perform intermediate calculations or store temporary results.

12. Error Handling: You can define error handling within the Mapper to handle errors that might occur during data transformation. This can include specifying how to handle data type mismatches or other mapping errors.

The Mapper in OIC is a versatile tool for data transformation, and its features allow you to handle a wide range of data mapping scenarios in your integrations. You can design complex mappings, apply transformations, and ensure that your data is correctly transformed from source to target structures.