Hi,
It is very common to use ODI user functions during the transformation and the below steps explains how a user function can be created and used with ODI 11g
In this example we will be converting the values of the status column to new values as shown below
Target Conversion
Create a new function from the Designer tab > Projects > Your project > User functions
The name of the function is StatusCONVERT and the Group name is Conversion
Navigate to the implementation tab and click on the + sign as shown below
Add the conversion statement as shown below and select Hypersonic SQL and Oracle as shown below
From the project function select the StatusCONVERT function that we created in the first step
Complete the flow configuration and execute the interface
It is very common to use ODI user functions during the transformation and the below steps explains how a user function can be created and used with ODI 11g
In this example we will be converting the values of the status column to new values as shown below
Create a new function from the Designer tab > Projects > Your project > User functions
The name of the function is StatusCONVERT and the Group name is Conversion
Navigate to the implementation tab and click on the + sign as shown below
Add the conversion statement as shown below and select Hypersonic SQL and Oracle as shown below
Create the interface and complete the source to target mapping as shown below.
From the mapping screen, select the status column on the target table and user the property inspector to add the function as shown below
From the project function select the StatusCONVERT function that we created in the first step
Complete the flow configuration and execute the interface
After the interface is executed successfully you can see that the target table have used our conversion function and the values are changed.
Hope this helps
Thanks,
Sandeep
This post first appeared on The Big Data - Business Intelligence By Sandeep Venu, please read the originial post: here