ODI - Using ODI user function with Interface or Package | The Big Data - Business Intelligence by Sandeep Venu

Enter key word

ODI - Using ODI user function with Interface or Package

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


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


SHARE

About Sandeep Venu

    Blogger Comment
    Facebook Comment

0 comments:

Top Links

Upgrading BI Publisher

Add Google Search

OBIEE- LDAP

Change Admin Password

Best Practices

ORACLE 11GR2

Host Files

Customization

OBIEE-SIEBEL

Bug Fixes

Setting Default

OBIEE Installation failed

OBIEE Installation

Oracle Databse

Oracle In Linux

Loopback Adapter

Weblogic Failed

Yum Commands

Weblogic Admin

Linux Static IP

OBIEE LDAP

Admin Paswword

Scaling

Weblogic Starting Error

Localizing BI

Physical Schemas

Multimedia Dashboard

Video in OBIEE

Variables in OBIEE

Ago 30 Days

Email Link

ODI Installation

AGO Function

Sort Pivote table

OBIEE Patch

Reset Sys password

Date Calculation

Add Row in Report

Increase Row limit

OBIEE with Essbase

Reset Weblogic

BIP Login Error

MDS and BI Platform

ORA 28001 Error

ORA 12560 TNS Protocal Error

ORA 12154 TNS Error

OBIEE ON AIX

Pre Requsite

AIX Commands

Commands