How to improve the performance of Aggregate
transformation?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

how to load rows into fact table in data warehouse

642


Explain constraint based loading in informatica

661


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1519


How to load a Dimension ? and how to load a fact table?

957


How do you load alternate records into different tables through mapping flow?

1298






How to start a workflow using pmcmd command?

715


Design time, run time. If you don't create parameter what will happen

1428


Explain the types of transformations?

598


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

543


Mention some types of transformation?

607


How can we create index after completion of load process?

600


What is an expression transformation in informatica?

519


what is song in infrmatica...?

1680


Do you find any difficulty while working with flat files as source and target?

677


What is xml source qualifier transformation in informatica?

714