Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / subhrangshu
We can use Scheduler option in Workflow to schedule the entire mapping.
Also, if we are using any central scheduler tool for this purpose, we can create a command file with PMCMD to run the workflow and schedule execution of that command file in a scheduler.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the way to execute pl/sql script using informatica mapping?
What is rank transform?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What does update strategy mean, and what are the different option of it?
What do you mean incremental aggregation?
How many transformations can be used in mapplets.
What if the source is a flat-file?
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 do you understand by term role-playing dimension?
Different sorts of metadata that stores in the storage facility?
EXL informatica Questions
What is a filter transformation and why it is an active one?
design of staging area?
What's the layout of parameter file (what does a parameter file contain?)?
