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

Detecting files with a variable name

Detecting files is actually a fairly trivial operation in ODI, but we have noticed that many people either do not know how to do it or even don't know that it is possible using ODI. Since detection is so simple, we will use this recipe to prepare the ground for the next two recipes.

Getting ready

For this recipe, we will detect when files are added to the c:\temp directory. Make sure that you have an instance of your file explorer ready. Create a directory c:\temp\landing and create three files in that directory: EMP001.TXT, EMP002.TXT, and EMP003.TXT. There is no need for any content in the files for this recipe. As part of this recipe, we will copy all three files into the c:\temp directory.

How to do it... ...

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