This content has been marked as final. Show 3 replies
1 person found this helpful
When my source team does not send a file, my job failsInstead of shell script you may go for EventWait object from Workflow Manager, this keeps wait for the file and on file existence can run the task.
In your workflow Start-->EventWait ->Session
Try it out this.
If helps mark
Edited by: Srini VEERAVALLI on Apr 3, 2013 9:51 AM
1. My src team sends a bunch of files with date&time extention.
My script move them to my src file dir, create a file list for indirect method(informatica) and then process these files.
According to you, if they put a semaphore file, then I can use event wait task.
2. We are running Informatica wkfs through DAC.
If I go by event wait task approach, on a particular day if src team does not send a file: my job will be waiting for the semaphore file.
In DAC Version we are using, when one job is running, all other jobs will be waiting in a queue.
To run jobs in parallel, we have to install a DAC patch.
So the whole idea is: If put a file name in my file list(for inderect method), my job will never fail.
Any ideas pls?
Make sure that any point of time there is a file; by default keep a file with a row can be number columns as 0 and char cols as null etc.
if the actual file comes in the directory your default file would override and DAC load the file in warehouse and make sure that your informatica workflow creates default file with a row as I said above before it complete.
You might using SIL mapping with update strategy that would take care of the above record to insert or update.