SQL queries are used for all components that extract data, mainly the Data Provider and Staging components. Queries are mandatory for those components because they define OUT-port structure.
To enter a query for the component, click the Query icon in the Properties window. You can:
Enter a query.
Run a query.
Save a query.
Open Query Designer. See “Query Designer”.
Look up the database schema.
