How to use DVM in ORACLE SOA

Step 1: Login to ESB console. (http://192.168.0.141:8888/esb/)

Step 2: Click the Maps icon in the console.

Step 3: Click the create button to create new DVM.

Step 4: Select a “Create a new map”.

Step 5:

• Double click on New DVM suppose if you want to change the name.
• If we click the add drop down we will get 2 options like

1-      Row: This is to add rows.

2-      Column: This is to add columns.

For example I took “Female” has to be replaced by “F” similarly “Male” has to be replaced by “M”. And click ok to the DVM.

Step 6: Now open the Jdeveloper & create a new ESB project as shown below.

Double click the “File_read_RS” to setup transformation & map as shown below.

Now select “Advanced Function” from component palette & drag and drop “Lookup-DVM” to the center of the transform.

Now make the connections as shown below.

Double click the DVM which we dropped & we will get the pop window as shown below to configure.

Put the cursor at the starting point of dvmname & click “Move Down” button twice.

• Click the torch icon in dvmname & select the DVM which we created.
• Click the torch icon in sourceColumnName and select ‘Domain1’.
• Click the torch icon in targetColumnName and select ‘Domain2’.
• DefaultvValue field is optional. It is used when the source value is not matched.

Note: Domain names will depends on DVM Creation.

Now deploy and check the output.