Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 ?    15 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 11 No

Post New Answer

More Informatica Interview Questions

which one is better either active or passive transformation in informatica

1 Answers  


what is inline view?

1 Answers   IBM,


PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  


In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,


i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  






What is depict expression change?

0 Answers  


how i will stop my workflow after 10 errors

2 Answers   HP,


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  


Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,


can u any challenge your project?

0 Answers   HP,


how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,


Categories