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 the substitution passes

We will look here at some of the details of how ODI uses multiple substitution rounds to replace some of the code within KMs with the actual code that will be ultimately executed by the databases and scripts.

Getting ready

To follow along with the examples listed here, you will need an ODI project with at least the following KMs: LKM File to SQL (SQLLDR) and IKM SQL Control Append. From a resource perspective, you will need a Flat File model with at least one file defined and an Oracle model with at least one table.

How to do it...

  1. In your project, rename the LKM File to Oracle (SQLLDR) KM, to LKM File to Oracle (SQLLDR) with substitutions.
  2. Edit the LKM File to Oracle (SQLLDR) with substitutions KM and within the step ...

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