When you enable lookup caching, the Data Integration Service queries the lookup source once, caches the values, and looks up values in the cache. Caching the lookup values can increase performance on large lookup tables.
When you disable caching, each time a row passes into the transformation, the Data Integration Service issues a SELECT statement to the lookup source for lookup values.