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