Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How to improve the performance of Aggregate
transformation?

Question Posted / guest

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 ?    16 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 ?    6 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 12 No

Post New Answer

More Informatica Interview Questions

What is enterprise data warehousing?

0 Answers  

What are the features of complex mapping?

0 Answers  

Explain the informatica workflow?

0 Answers  

Parameter and variable differences

0 Answers  

Define enterprise data warehousing?

0 Answers  

What are junk dimensions?

0 Answers  

What is metadata reporter?

1 Answers   Informatica,

can u any challenge your project?

0 Answers   HP,

Explain target update override in informatica

0 Answers   Informatica,

what is scd?

6 Answers  

What is expression transformation?

0 Answers  

What is informatica?

0 Answers  

For more Informatica Interview Questions Click Here
Categories