The Data Integration Service retrieves the number of rows based on the value entered. If you do not enter a value, the Data Integration Service retrieves all the rows. For example, you can test a mapping by retrieving a sample of rows.

If you configure sorted ports in the read operation properties, the Data Integration Service retrieves the number of rows based on the sorted data output. If you do not configure sorted ports in the read operation properties, the Data Integration Service retrieves the number of rows based on the behavior of the third party server.