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

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.