You can configure a cached connected Lookup transformation in a mapping. A connected Lookup transformation is connected to a MongoDB source or target in a mapping. When you create a cached lookup, the performance increases because the Integration Service caches a large lookup source or small lookup tables. When you cache the lookup source, the Integration Service queries the lookup cache instead of querying the lookup source for each input row.