SQL queries are used for all components that extract data, mainly the Data Provider Components and the Staging Components. Queries are mandatory for those components because they define OUT-Port structure.
To enter a query for the component, select the Query option of the Query property.
From the Query window you can:
Enter a query
Run a query
Save a query
Open the Query Designer
Look up the database schema
