---
title: "Informatica – Source Optimization"
description: "The source optmization in Informatica is optmizing your SQL query. So that it will take less time to import your data into Informatica from RDBMS databases. Read more."
url: https://srinimf.com/2013/12/19/informatica-source-optimization/
date: 2013-12-19
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2021/09/pexels-photo-3987066.jpeg?fit=1880%2C1253&ssl=1
categories: ["Informatica"]
tags: ["Informatica Transformations"]
type: post
lang: en
---

# 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](http://srinimf.com/2013/12/07/informatica-version-9-5-latest-features/) (srinimf.com)

Related[Informatica – Session Performance](https://srinimf.com/2013/12/17/informatica-session-performance/)

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2013%2F12%2F19%2Finformatica-source-optimization%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2021%2F09%2Fpexels-photo-3987066.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=Informatica%20-%20Source%20Optimization)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2013/12/19/informatica-source-optimization/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2013/12/19/informatica-source-optimization/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2013/12/19/informatica-source-optimization/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2013/12/19/informatica-source-optimization/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20Informatica%20-%20Source%20Optimization&body=https%3A%2F%2Fsrinimf.com%2F2013%2F12%2F19%2Finformatica-source-optimization%2F&share=email)
-

### Like this:

Like Loading…