Guys,
Please help me.
This is an urgent request.
If any one of you have ever done this in your Informatica developments,
share with me the experience or suggest the work around.
I have a workflow ready with its task (session).
This reads a flatfile and do populate Oracle target table.
Now, I need to do a sheduling and it needs be as follows.
Workflow will start on its sheduled time, will look for
the source. If it finds the same that's fine and will go
ahead.
If not, then the workflow will give a 2nd attempt after 30 minutes.
In it's second attempt, if it finds the file, then will continue with loading
If not, then will give a final attempt after next 30 minutes and if the source
file had arrived by that time, loading will be carried on.
But, by this 3rd attempt, if the source file is not still
available an e-mail will be sent stating the non-availabilty
of source.
Thanks
PS:- I am using Informatica ver 6.2
Please help me.
This is an urgent request.
If any one of you have ever done this in your Informatica developments,
share with me the experience or suggest the work around.
I have a workflow ready with its task (session).
This reads a flatfile and do populate Oracle target table.
Now, I need to do a sheduling and it needs be as follows.
Workflow will start on its sheduled time, will look for
the source. If it finds the same that's fine and will go
ahead.
If not, then the workflow will give a 2nd attempt after 30 minutes.
In it's second attempt, if it finds the file, then will continue with loading
If not, then will give a final attempt after next 30 minutes and if the source
file had arrived by that time, loading will be carried on.
But, by this 3rd attempt, if the source file is not still
available an e-mail will be sent stating the non-availabilty
of source.
Thanks
PS:- I am using Informatica ver 6.2