How to improve the performance of Aggregate
transformation?
- 3 Answers
- 12889 Views
- Dmss, I also Faced
- E-Mail Answers
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
What is sequence generator transformation in informatica?
Explain lookup transformation in informatica
What is intricate mapping?
Where can we find the throughput option in informatica?
Write the different tools in the workflow manager?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are data-driven sessions?
Differentiate between Load Manager and DTM?
What is a joiner transformation?
Target increases every day even though no new record was inserted
how tokens will generate?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How can we improve session performance in aggregator transformation?
What is meant by query override?
what is unit testing?tell me proceedure
