A mapping that contains a pipeline Lookup transformation includes a partial pipeline that contains the lookup source and a source qualifier. The Integration Service processes the lookup source data in this pipeline. It passes the lookup source data to the pipeline that contains the Lookup transformation and it creates the cache.
The partial pipeline is a separate target load order group in session properties. You can configure multiple partitions in this pipeline to improve performance.