Interested to Buy Any Domain ? << Click Here >> for more details...
create a mapping to retrieve the employees who are getting
salary greater than average salary?
- 4 Answers
- 10750 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / shaik
Source--->EXP--->AGG--->Filter--->Target
by using agg T/f you can find the avg,use that value ti
filter the values by using filter transformation..............
| Is This Answer Correct ? | 4 Yes | 15 No |
Post New Answer View All Answers
Quickly characterize reusable change?
What is the difference between STOP and ABORT options in Workflow Monitor?
lookup transformation with screenshots
How to partition the Session?
What is a node in Informatica?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is informatica powercenter repository?
What is informatica?
Explain lookup transformation source types in informatica
What are the advantages of informatica?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER 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
How many types of sessions are there in informatica.please explain them?
What is the advantage of informatica?
What is InformaticaPowerCenter?
