top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Workflow scheduling in Informatica

+1 vote
277 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
Performance tuning of session and workflow in Informatica?

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

0 votes
Send a Flat file attachment in the workflow in Informatica Developer

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
find the list of mapping and workflow affecting the particular table in informatica

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
Informatica: Pass date value from one session to another session in the same workflow

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?

...