Advanced Lookup Cache Transform
The "Advanced Lookup Cache Transform" is used to store rows from a source into an in-memory or on-disk cache. See the Advanced Lookup Cache Connection Manager page to learn more about setting up the connection manager.
• Choose Cache Connection Manager - You can select an existing "Advanced Lookup Cache Connection Manager" or choose to create a new one.
• Map Cache Columns - After a Cache Connection Manager has been selected, the input columns and columns from the cache will be automatically mapped if the names match. Otherwise you will need to manually map the columns.