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 substitution methods in Java

For this recipe, we will make a very simple modification to the IKM SQL Control Append by combining a Java variable and a substitution API. Then we will use this KM in an interface to see how the code gets generated.

Getting ready

You will need to have a project ready where the IKM SQL Control Append KM has been imported. You must also have a table that can be used as a target table using this IKM in an interface.

How to do it...

  1. Rename the IKM SQL Control Append KM to IKM SQL Control Append with Variable and Substitution.
  2. Add a step. Name the step Retrieve Session Number and write the following code in that step:
    <%v_sess=odiRef.getSession("SESS_NO")%>

    Tip

    There is no need to set the technology for this step: as you ...

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