Have the mapping not fail if the source data file is absent

3673816

Hi Forum.

Does anybody have any recommendations on how to handle a situation in ODI when a flat file that mapping first loads from (first interface between the flat file datastore and a staging table datastore) is absent and not have the mapping fail, but rather have the rest of the package continue on?

A typical use case would be:

Our package deals with loading a bunch of files that come in as a batch.

Everything get loaded into target tables as a full replace (truncate / control append).

Some days only some of the files may come in. The others may not.

In cases like that, we would not want the whole package to trip up on the absent file, but rather keep the target table intact (not truncate, i.e. use previous days' data), but we would load the other target tables whole new flat data files did come in.

Thank you

Boris

Adrian_Popescu-Oracle

Hi Boris,

You can try to use a procedure with Jython code.

os.path.exists(path) returns True if the path exists.

Adrian

Adrian_Popescu-Oracle

Hi Boris,

You can try to use a procedure with Jython code.

os.path.exists(path) returns True if the path exists.

Adrian

842395

using wait file event in package

3673816

Thank you Adrian for your recommendation.

Boris