Developer Transformation Guide

10.5
- 10.5.2
- 10.4.1
- 10.4.0

Back Next

Maximum Output Row Count

You can limit the number of rows that the SQL transformation returns for SELECT queries. Configure the

Max Output Row Count

property to limit number of rows. When a query contains multiple SELECT statements, the SQL transformation limits total rows from all the SELECT statements.

For example, you set

Max Output Row Count

to 100. The query contains two SELECT statements:

SELECT * FROM table1; SELECT * FROM table2;

If the first SELECT statement returns 200 rows, and the second SELECT statement returns 50 rows, the SQL transformation returns 100 rows from the first SELECT statement. The SQL transformation returns no rows from the second statement.

To configure unlimited output rows, set

Max Output Row Count

to zero.

Input Row to Output Row Cardinality

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal