The default lookup query contains the following statements:
SELECT
The SELECT statement includes all the lookup ports in the mapping. To view the SELECT statement for the lookup query, select the
Lookup SQL Override
property.
ORDER BY
The ORDER BY clause orders the columns in the same order they appear in the Lookup transformation. The Integration Service generates the ORDER BY clause. You cannot view this when you generate the default SQL.