Hi all,

I am planning to load data from a flat file using an external table in an OWB mapping. Will my mapping work correctly if my file name changes at every load...as an example file name in October is sales_200310 in november it will be sales_200311.

In case OWB cannot handle this kind of variable file name then does it allow to include a pre mapping script (shell script or batch command) to change the flat file name to a standard name each time the mapping is executed.

Pls. suggest a workaround for this problem.

My environment -- Oracle 9i, OWB 9.2

Thanks in advance.

Regards,
Amit.

Igor,

Thanks for your response.

Does OWb allow us to run a shell script as a pre mapping process or does it have to be done as a pl/sql package which calls a shell script.

Regards,
Amit.