How to increase ETL performance in Informatica for Netezza as a source and SQL Server as a target?
2
votes
2
answers
3277
views
What settings or configuration on the Informatica server, in the Informatica software itself, or on the database servers can be changed to increase Informatica ETL throughput? What are some benchmarks we can set to troubleshoot performance? We are specifically using Netezza as a source and SQL Server as a target.
Please exclude multi-threading and Informatica partitioning from this question.
This we've done in the past:
- restart servers every so often
- remove indexes on target tables in SQL Server before ETL load
- increase commit level
Asked by JustBeingHelpful
(2116 rep)
Aug 19, 2015, 04:33 PM
Last activity: Mar 13, 2016, 10:50 AM
Last activity: Mar 13, 2016, 10:50 AM