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

Processing all files in a directory

Now that we have a mechanism in place to detect files, it will be important to know which files are available in order to process them. Today we may be receiving EMP001.TXT, EMP001.TXT, and EMP003.TXT. Later we may receive other similar files. If the sequence of file names can easily be predicted, we can build the expected names in a variable and wait for the expected file. However if the file names are unpredictable and random, then we need to know what we have received before we can process them. This is what we will focus on within this recipe.

Getting ready

We can start from where we left off in the previous recipe and build the examples of this recipe into that package, or we can create an entirely new package. ...

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