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

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.