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

Defining packages and loops for near real-time execution using a hybrid loop

There are many use cases where a specific job may require execution on a continual basis, perhaps the most common of which is when using a changed-data-capture process. A commonly occurring situation in Changed Data Capture (CDC) environments is the requirement that the ELT processes continuously monitor for data changes on the source system, rather than simply executing on a fixed schedule.

Unfortunately, a perpetual ELT process presents some logistical problems such as how to efficiently manage the job logs in the Operator navigator and how to afford an administrator the opportunity to terminate and restart the job. For example, if an ODI scenario is designed to recursively ...

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