Warning. Unsorted input found when building the cache for the Lookup transformation <transformation name>. The current number of entries in the index cache is <number of entries>. The cache will be built by insertion. This will cause it to take longer and the index cache may require more space.
The SQL in the Lookup transformation does not sort data in the sort order that the Integration Service expects. The SQL sorts data in an incorrect order due to an ORDERBY clause in the SQL or because the user-defined SQL override retrieves the port data in a different order.
To improve performance, review the SQL and fix the SQL to retrieve data in the sort order that the Integration Service expects.
The sort order settings for the database server and Integration Service do not match.
To improve performance, configure a consistent sort order for the database server and the Integration Service.
