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 output port structure.

The SQL query result set must contain at least one column. This is an example of a SQL query:
SELECT cu_no, cu_name FROM customers
Parent topic: Working with SQL Properties