File Watcher
As we having most of the loads which are depends on upstream applications which keep sending us files and for stipulated time we have to run workflow and if fileis available then workflow will process file else it will fail for no file present .
We can implement something like when I start my workflow it will keep waiting for file untill it comes and not fail . once file come it will start processing file .
Sometimes we receive the file but as usual if file size is too big it takes some time to copy file and informatica wont wait for it as it will start processing as soon as file comes .
In these kind of scenarios we created a flag / key / pass file . it will normally 0 kB file which is just an flag to tell system that its good to go .
Lets implement a simple scenario where we will start the workflow but it will keep waiting for the file and as soon as I copy file in required folder it will start process .
First I will take a simple workflow and execute it without filewatcher and then we will introduce filewatcher for the same workflow and execute it
Simple workflow which is loading 1 file to target oracle table .
Simple wokflow will be like below
Once I start this workflow it will start processing the file which I already kept at location
And it completed successfully .
Now I will introduce a simple task in informatica EVEN WAIT which will be used as file watcher.
Workflow will look like below .
We have mentioned that eventwait task will be a filewatcher and and it will wait for file as mentioned .
Now I moved the file to some another folder from its path D:\
Now lets execute the workflow.
As you can see as soon as I copied the file workflow continued with nest task which will load data to target
