O'Reilly logo

Oracle Data Integrator 11g Cookbook by Peter C. Boyd-Bowman, Denis Gray, Christophe Dupupet, Julien Testut

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Java variables in KMs

For this recipe, we will make a very simple modification to the IKM SQL Control Append KM using a Java variable. Then we will use this KMs in a series of interfaces to see how ODI handles the variable.

Getting ready

You will need to have a project available where the IKM SQL Control Append KM has already been imported. You must also have a few tables that can be used as target tables using this IKM (think of 3 or 4 tables).

How to do it...

  1. Rename the IKM SQL Control Append to IKM SQL Control Append with Variable.
  2. Right-click on the IKM SQL Control Append with Variable KM and add New option. Call this option Reset Java Variable. Set the type to Check Box and the default value to FALSE.
  3. Edit the KM IKM SQL Control Append with ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required