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 do unit testing in informatica? How to load data in informatica ?
What could be the possible resons of locks by user?
What do you mean by filter transformation?
What are the new features of informatica 9.x developer?
What does cheating measurement mean?
What are the main features of Oracle 8i with context to datawarehouse?
On which transformations you created partitions in your project?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How do you load alternate records into different tables through mapping flow?
Have you worked with/created Parameter file
Make a note of the quantity vaults made in informatica?
tell me the rules and responsblites in our project(my project is development)
What are the basic requirements to join two sources in a source qualifier transformation using default join?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Differences between version 7.x and 8.x.