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

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.