Interested to Buy Any Domain ? << Click Here >> for more details...
My source contains 10 records with 5 columns.What happens if I
select group by all columns in Aggregator T/R?
- 3 Answers
- 7944 Views
- I also Faced
- E-Mail Answers
Answer Posted / rayudu
If you select groupby on all the ports you will get distinct records only.
| Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
What is the reusable transformation?
What is target designer and target load order?
What does cheating measurement mean?
When do you use sql override in a lookup transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
tell me about your project functionality
What you know about transaction control transformation?
What do you mean by blocking transformation?
How do you set a varible in incremental aggregation
What is the function of look up transformation?
Define mapping and session?
what is unit testing?tell me proceedure
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
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 are the components of workflow manager?
