Source Qualifier Transformation

Explain about Source Qualifier transformation

Source Qualifier transformation is an active transformation which read or extract the data from the database and flat files

SQ can be used to

• Join tables from same data sources
• filter the rows when the Integration service (it adds a WHERE clause to the query) reads the data from the data source
• specify the sorted ports. The Integration service adds a ORDER BY clause to the query with sorted ports
• select distinct values from the source. the Integration service adds a SELECT DISTINCT clause to the query 

SQL override: It is a process of changing the default SQL generated by Source Qualifier transformation

Source Filter: If the source is a database the Informatica recommends to use source filter condition rather than using filter transformation. It improves performance of data extraction