Informatica – Source Optimization

Source optimization is the combination of Database and Informatica tuning.
Optimizing Query

1. When multiple sources added to one SQ. Always use query with optimizing hints.
2. Use single table select statement with Order by and Group by
3. Check with DBA about query tuning. The queries present in the SQ and/or Session log. Try to implement Hints on queries.
4. Creating order by and group by avoids creating indexes
5. Use SQ conditional filter to improve performance etc..
6. Increase database network pocket-size
7. Sybase/Mysql, try to create Tempdb to improve performance

Related articles

• Informatica Version 9.5- Latest Features (srinimf.com)