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

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,


What is an active transformation?

0 Answers   Informatica,


What are the reusable transforamtions?

2 Answers  


following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,


If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   WalMart, IBM,






my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,


WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,


what is difference between dimention table and fact table?

1 Answers  


difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,


why union transformation is active transformation?

6 Answers   TCS, IndiGo,


if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,


Can anyone tell me the new features in Informatica 9 Version?

2 Answers   Syntel,






Categories