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

Combining substitution methods in a KM

There are times where we need to use more than one substitution method to obtain what we need. We may need to concatenate the results of two methods, or to use one method to get the parameters for another. For such cases, the typical question is where and how to use the enclosing brackets. We will show some of this here.

Getting ready

For this recipe, we will make a very simple modification to the IKM SQL Control Append KM by combining several substitution methods. Then we will use this KM in an interface to see how the code gets generated. You will need to have a project ready where the original IKM SQL Control Append KM has been imported. You must also have a table that can be used as a target table using ...

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