Learning Informatica PowerCenter 10.x - Second Edition

Using the WHERE clause

You can add the WHERE clause in the SQL query while you override the default query. When you add the WHERE clause, you reduce the number of records extracted from the source. This way, we say that our Source Qualifier transformation is acting as Filter transformation. You can also define the WHERE condition in the Source filter. If you define the source filter, you need not add the WHERE clause in the SQL query. You can add the source filter as shown in the following screenshot: