what is the run frequency to process this file.
If more than one, would better to maintain control table with paramter value in paramter file.
Its not a fixed frequency.
Usually the frequency will be once a day from Monday to Saturday.
But nw and then we amy receive two files on one day and no files on the other day.
I this scenario how can I handle this?
Thanks in advance.
To handle such situation create a batch file and run it in command task. What this batch file do is to act as a file watcher in every twenty seconds say. If it finds a file it creates a 0 byte indicator file. This should also be the indicator filename in your event wait task. The workflow would run and process your files. Make sure you use indirect mode of loading files using filelist. You would haveto work out with batch scripts to achieve this.
To achieve this, we need to have one assigment task and one eventwait task.
1. Create a new workflow variable as "$$NEWVARIABLE1" as "nstring" datatype
2. Create a "Assignment" task and assign "to_char(sysdate,'dd-mon-yyyy') as the value for
3. Create a Eventwait task and your filewatch name should be as "c:\abc_
Start_task -> Assignment_task -> Event_wait_task
I tested this in my windows machine by placing a file in C:\ drive as "abc_22-Nov-2013.txt"
It may e too late to ask question on this post. But I have one query here
does flow will be
Start --> CommandTask --> EventWaitTask --> SessionTask
and if yes then in Eventwait task we will get fileame then what is need of Indirectfileloading in sessionTask?