SQL queries are used for all components that extract data, mainly the Data Provider and Staging components. The columns of the query result set define the respective OUT-port structure.
The SQL query result set must contain at least one column. Example of a SQL query:
SELECT cu_no, cu_name FROM customers