...
On lookup pipes, you can define a cache extraction filter.
For a Pipe set up in this way, data is help Lookup pipes hold retrieved data in a memory cache.
For each record processed in the Stream, records are retrieved from the cache using the index expressions. But the data required for each record can be further filtered using a Cache Extraction Filter.
...