Lookup Transformation Editor (Advanced Page)

Cache size (32-bit)

Adjust the cache size (in megabytes) for 32-bit computers. The default value is 5 megabytes.

Cache size (64-bit)

Adjust the cache size (in megabytes) for 64-bit computers. The default value is 5 megabytes.

Enable cache for rows with no matching entries

Cache rows with no matching entries in the reference dataset.

Allocation from cache

Specify the percentage of the cache to allocate for rows with no matching entries in the reference dataset.

Modify the SQL statement

Modify the SQL statement that is used to generate the reference dataset.

Note
The optional SQL statement that you specify on this page overrides and replaces the table name that you specified on the Connection page of the Lookup Transformation Editor. For more information, see Lookup Transformation Editor (Connection Page).

Set Parameters

Map input columns to parameters by using the Set Query Parameters dialog box.

Blog entry, Lookup cache modes on blogs.msdn.com

Reference

Concepts