Database Reference
In-Depth Information
Viewing the default query
When you use the relational database as a source, the source qualifier generates a default
SQL query to extract the data from the database table. By default, Informatica extracts all
the records from the database table. To check the default query generated by Informatica,
perform the following steps:
1. Double-click on the Source Qualifier transformation, click on the
Properties
tab,
and select the SQL query.
2. The SQL editor opens up. Click on the
Generate SQL
option. If required, specify
the database username and password.