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 variables to control loops inside packages

Process control looping is a commonly used technique in many forms of software development and the need for such methods is no different in ODI. There are many use cases where managing the exact number of process cycles is a functional requirement. By using separate steps to initialize, increment, and evaluate the value of a designated loop-control variable, an ODI developer is able to tightly manage the process cycles needed to satisfy those requirements. In this recipe, we will develop a package that executes an interface a specific number of times before terminating.

Getting ready...

In order to give our package something to do, we will reuse the Int_Variable interface created earlier in the ...

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