ODI is not limited to the datatypes that it knows out of the box. In this recipe, we will create an entirely new datatype and we will leverage it in an interface to see how it can be handled.
For this recipe, you will need a project where the following KMs have been imported:
LKM SQL to Oracle
IKM SQL Control Append
First we will create a new datatype in the database. You can do this with many databases; our example here is with Oracle. Use your favorite tool to connect to the database (SQL+, SQL Developer, Toad, and so on). If you re-created the environment described in the Preface of this book, log in as the owner of the source schema
DEMO_SRC
and enter the following commands:create type FULL_SALARY AS OBJECT (BASE_SALARY number(8), BONUS_SALARY number(8)); create table SRC_YEARLY_SALARY ( EMP_ID number(4), YEAR number(4), SALARY full_salary);
Go to ODI Topology. If you followed the first recipe of this chapter, you...