Select Single is an open SQL command that returns one row from the SAP ECC source. When you use open SQL, the Designer generates a Select Single statement for each source definition you configure with the Select Single option.

You might use this option with a nested loop join when you want to join tables based on key values in one table. The inner loop with Select Single matches one record for each join condition. Select Single improves performance in the select loop by selecting a single row of data rather than the entire table.

Select Single is not available with the following options: