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 ...

Get Oracle Data Integrator 11g Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial