How to improve the performance of Aggregate
transformation?




Answers were Sorted based on User's Feedback



How to improve the performance of Aggregate transformation?..

Answer / deepthi

1.Use sorted data and enable option 'sorted i/p'
2.By using incremental aggregation
3.group by simple columns like numeric columns
4.use filter transformation before aggregator to avoid
unnecessary aggregation on unwanted columns.

Is This Answer Correct ?    14 Yes 0 No

How to improve the performance of Aggregate transformation?..

Answer / ritu

By giving sorted inputs and do not forget to tick the
sorted input box

Is This Answer Correct ?    5 Yes 0 No

How to improve the performance of Aggregate transformation?..

Answer / uzval_vee

Place the agg transformation after souce qualifier,becoz
if yur using filter,sorting before agg ,it will reduce the
agg performance .according to my view

Is This Answer Correct ?    1 Yes 11 No



Post New Answer



More Informatica Interview Questions

what is filelist concept in informatica

4 Answers  


What is mapplet and a reusable transformation?

2 Answers  


If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,


Why should we use star schema in datawarehouse design?

2 Answers   Wipro,


What is the difference between Bulk Load and Normal Load

3 Answers   TCS,






What is the difference between Active and Passive transformation?

0 Answers   Informatica,


What are the new features of informatica 9.x developer?

0 Answers  


how do u move the code from development to production?

6 Answers  


what is the difference between static and dynamic

4 Answers   Wipro, TCS,


How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,


I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   TCS, ITC Infotech,


My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers  






Categories