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
DEMO_SRCand enter the following commands: