Oracle Data Integrator 11g Cookbook

Chapter 8. Package Loops and File Processing

In this chapter, we will cover:

• Defining packages and loops for near real-time execution using a hybrid loop
• Using a file from a parameter variable
• Detecting files with a variable name
• Processing all files in a directory
• Processing a large number of files in parallel

Introduction

Experience has shown that many ODI developers limit their workflows by using only the most basic methods because they do not know how to implement more mature integration techniques. ODI offers a rich set of utilities and tools, looping controls, synchronous and asynchronous process invocations, and load plan management, which collectively can provide any developer the means to deliver elegant solutions to the most complex problems. ...