Using a file from a parameter variable

There are times when it may be necessary to load data from a file without knowing the exact name of the file prior to execution. To handle this unique situation, ODI provides a convenient method for developing an interface that references a data store with a variable resource name. All that is required at runtime is simply to pass a parameter containing the actual name of the file that needs to be processed.

This recipe will demonstrate how an interface can be developed initially using a known data store after which the resource name of that data store is replaced with an ODI variable. The interface can then be called from a package that accepts the true value or the resource (file) at runtime.

Getting ready ...

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.