Interested to Buy Any Domain ? << Click Here >> for more details...
which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..
- 7 Answers
- 13631 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / raghu
aggregater is costliest bcoz it have cache, remaing d'snt
have cache
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
where to store informatica rejected data? How to extract the informatica rejected data?
How to update or delete the rows in a target, which do not have key fields?
Explain what transformation and how many are there in informatica?
permutations of mapplet
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Explain sessions. Explain how batches are used to combine executions?
How does a rank transform differ from aggregator transform functions max and min?
How to create the source and target database connections in server manager?
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 performance considerations when working with aggregator transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What do you understand by term role-playing dimension?
What is an unconnected transformation?
Enlist the differences between database and data warehouse.
