Previous Next JavaScript must be enabled to correctly display this content

## 5.1 Data Transformation and Mapping

Oracle Banking Electronic Data Exchange for Corporates provides maintenance for data transformation and mapping for fields at the Bank level.

This maintenance will be used to create, view and edit the data that needs to be supported or transformedin specific cases.

Table 5-1 Supported Transformations Operations as given below -

Supported | Operation | Remarks
--- | --- | ---
 | Transform a given Data Value | Can assign a predefined value for an incoming data in for the column selected. Multiple unique incoming value can be transformed to predefined values.
 | Assign Fixed or Variable Values | Can assigna fixed or variable (random value) to fields which are not mapped using File Definition
X | Splitting of Data | Can Split data coming in one field to multiple fields

DataTransformation:

This screen can be invoked by clicking on the ‘gear’ icon next to the mapped columns in the Format Definition and Mapping page.

Figure 5-1 Data Transformation

Description of "Figure 5-1 Data Transformation"
Description of "Figure 5-1 Data Transformation"

1. Refer to the following table for specifying details in the above screen:

   Note:

   Fields marked with ‘*’ are mandatory.

   Table 5-2 Field Description

   Field Name | Description
   --- | ---
   Enrichments
   Add Row Button | Brings up an option to edit and maintain the data transformation
   From | Allows to select the incoming value to transform
   To* | Define the transformed value
   Map As-Is | Keep any other values that are not configured above, as is.
   Map As | Map any other values that are not configured as a part of From and To, to a pre-defined value.

View Data Transformation

Note:

Refer to ‘View Format Definition and Mapping’ section under File Format Definition and Mapping

Parent topic: Data Transformation