Database Reference
In-Depth Information
Overriding the default query
We can override the default query generated by the Source Qualifier transformation. If you
override the default query generated by the source qualifier, it is called an SQL override.
You should not change the list of ports or the order of the ports in the default query. You
can write a new query or edit the default query generated by Informatica. You can perform
various operations while overriding the default query.
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 can say that our Source Qualifier transformation is acting as a 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:
Search WWH ::




Custom Search