top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Workflow scheduling in Informatica

+1 vote
114 views

My requirement is:
1.Workflow should run daily at 2pm. Workflow has been scheduled to run at 2pm
2.We have lookup on master tables. Records with IDs that are not present in the master tables will get rejected.
3.These new IDs have to be loaded into the master tables manually and then the workflow has to be re-run.
4.Daily the same thing happens.

My question is -

Is it possible to schedule a workflow to run twice every day(one for the first run, the other to run after the master table is updated)? If No, can I manually start a scheduled workflow? Will it make the workflow unscheduled?

Please, Can any one help me with this?

posted Nov 18, 2014 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Informatica's scheduler is a weak spot. I guess using two copies of the same workflow with different schedules would be the easiest solution.

answer Nov 21, 2014 by Shweta Singh
Similar Questions
+2 votes

How to tune the session, workflow for better performance, what are the things we consider for better performance?

0 votes

In a mapping we use delimited flat file having 3 columns.The column separated through comma. But i have a requirement that in between the column there is a column having 2 comma.So how should I process the column in the mapping?

0 votes

Can anyone tell me how to find the list of mapping and the workflow that are using a particular table say X either as a source or target table?

+2 votes

I have two sessions I a workflow like below

workflow1->session1->session2

I have a join_date column in a table in Mapping1 , in session1. I want to pick this join_date value and pass to mpping2/session2

If join date value changes in the table in session1 then the same value should pick and pass to session2. I will use this date value in a query in session2 .

Please suggest how to achieve this?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...