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
how to load rows into fact table in data warehouse
Explain constraint based loading in informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How to load a Dimension ? and how to load a fact table?
How do you load alternate records into different tables through mapping flow?
How to start a workflow using pmcmd command?
Design time, run time. If you don't create parameter what will happen
Explain the types of transformations?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Mention some types of transformation?
How can we create index after completion of load process?
What is an expression transformation in informatica?
what is song in infrmatica...?
Do you find any difficulty while working with flat files as source and target?
What is xml source qualifier transformation in informatica?