What is the difference between Power Centre and Power Mart?
Answer Posted / mubbasir
Informatica PowerCenter - has all options, including
distributed metadata, ability to organize repositories into
a data mart domain and share metadata accross
repositories,Partioning is available.
Informatica PowerMart - a limited license (all features
except distributed metadata and multiple registered
servers). No Partioning is available.
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Explain sql transformation in script mode examples in informatica
What is the benefit of session partitioning?
How to create or import flat file definition in to the warehouse designer?
How can you validate all mappings in the repository simultaneously?
how to load rows into fact table in data warehouse
How to do the error handling of if ur source is flatfiles?
Briefly define reusable transformation?
Explain what is informatica metadata and where is it stored?
On which transformations you created partitions in your project?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Which files are created during the session rums by informatics server?
How do you change a non-reusable transformation to reusable transformation?
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 a joiner transformation and why it is an active one?
Explain the informatica workflow?