1. User Guide
  2. Data Transformation
  3. Data Transformation and Mapping

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 follows
Description of "Figure 5-1 Data Transformation"


Description of Figure 5-1 follows
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