Can we schedule a workflow(not a session) to run after
completition of another workflow? Can we make a workflow
depend on completition of another one?

Answer Posted / santosh kumar sarangi

Different type of scheduler are there in market for this
purpose like WLM(Work Load Manager), Control M.

If you want to do it through informatica then after
completion of all the session of first work flow keep
command task and with in the command task call the next work
flow through pmcmd command.

Let me know if i am wrong.
Santosh Kumar Sarangi

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a joiner transformation and why it is an active one?

582


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1092


tell me about your project functionality

1870


Performance tuning in UNIX for informatica mappings?

2152


How to differentiate between the active and passive transformations?

631






How can informatica be used for an organization?

656


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1244


Is there any way to read the ms excel datas directly into informatica?

553


rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg

1534


Explain the difference between mapping parameter and mapping variable?

608


What are the different components of powercenter?

588


What is the function of aggregator transformation?

582


How might you approve all mappings in the archive all the while?

606


explain one complex mapping with logic? sales project?

6155


Can we get 1st record through Informatica(without sequence number).

995