Answer Posted / john
Mapplet is a reusable object which is used to reuse the
transformation logic.By using Mapplet designer we can
create the mapplet which is for reuse the set of
transformation logic.
Eg:suppose if you have developed one complex mapping which
has some complex logic involved in it.and you want to use
the same logic in another mapping also.then what u will do
generally..will you create the same logic again..No.You can
use the same logic by using mapplet.Mapplet is used for
storing the reusable set of logic(i.e no.of transformations
involved in it).So you have to know first whether the logic
which you are going to develop is useful in future or not
before developing the any mapping..If yes then create
mapplet in the mapplet designer first and then use that
mapplet in any other mapping.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the sequence generator transformation in 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
What is informatica metadata and where is it stored?
How to load last n records of file into target table - informatica
What is deployment group?
can you please explain me pre session and post session options?
What are the different options available for update strategy?
Explain incremental aggregation in informatica
how to load rows into fact table in data warehouse
What are the restrictions of union transformation?
What is the use of target designer?
Define joiner transformation?
What can we do to improve the performance of informatica aggregator transformation?
How can one identify whether mapping is correct or not without connecting session?
How we can use union transformation?