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.