I wanted to develep the workflow which continuously running and looking for the file..
The source file data is like this :
Once the file received in the FTP location , the workflow should automatically pick the file and load into the target Table.
The output of target table table will be like below
the condition to load the target table would be [ Update EMP_TGT set Received='Y' where eno=' ]