Queries

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