When you configure a Lookup transformation in a mapping, you can cache the lookup data during the runtime session.
When you select
Lookup Caching Enabled
, Data Integration queries the lookup source once and caches the values for use during the session, which can improve performance. You can configure dynamic lookup caching and can specify the directory to store the cached lookup.
You cannot perform insert and update operations to the same target at runtime when you dynamically cache the lookup objects in a mapping.
For information about lookup caching, see the chapter " Lookup transformations" in
ASK BOLOPreview
