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 / jack patel
yes,we can schedule a 1workflow after 2 workflow make a dependent on first one.
ex: if we have 5 workflow and we want to schedule a job in production. just do dependent on previous one..
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In which transformation you cannot drag ports into it?
What is a sequence generator transformation?
How union transformation is used?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain the etl program with few examples.
scenario where i can use only concurrent execution of workflow.
What is the sql query overwrite in source qualifier in informatica
Explain the difference between mapping parameter and mapping variable?
What is a rank transform?
What is fact table? Explain the different kinds of facts.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How big was your fact table
How can you validate all mappings in the repository simultaneously?
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
What is resilience time?