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
What is a joiner transformation and why it is an active one?
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)
tell me about your project functionality
Performance tuning in UNIX for informatica mappings?
How to differentiate between the active and passive transformations?
How can informatica be used for an organization?
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?
Is there any way to read the ms excel datas directly into informatica?
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
Explain the difference between mapping parameter and mapping variable?
What are the different components of powercenter?
What is the function of aggregator transformation?
How might you approve all mappings in the archive all the while?
explain one complex mapping with logic? sales project?
Can we get 1st record through Informatica(without sequence number).