Interested to Buy Any Domain ? << Click Here >> for more details...
Why can't we use few transformations in mapplet ? like xml
and target defintions, seq etc ?
- 2 Answers
- 9758 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / srinu
If it allows Target and other transformations instead of
mapplet we can very well use Mapping.
Mapplet nothing but(parameter concept) set of
transformation logic you can use for similar kind of
mappings and save your time.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is InformaticaPowerCenter?
What is meant by active and passive transformation?
What is the sql query overwrite in source qualifier in informatica
What is the scenario which compels informatica server to reject files?
Differentiate between sessions and batches?
What is informatica metadata and where is it stored?
What is meant by target load plan?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the benefit of session partitioning?
What is a node in Informatica?
What is the cumulative sum and moving sum?
what are factless facts? And in which scenario will you use such kinds of fact tables.
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
Enlist the advantages of informatica.
how many types of dimensions are available in informatica?
