Skip to main content

Use Cache Lookup

Determines if the PSA lookup caches the data to disk when using SSIS. Use this if it is not possible to use the normal in-memory lookup behavior due to memory constraints.

When enabled for a persistent, non-pushdown SSIS load, the generated package adds a dedicated cache data flow that reads the row hash and record source from the PSA into a lookup cache, and the PSA lookup uses that cache instead of the standard in-memory lookup.

When to Change This Setting​

Keep the default N for the standard in-memory PSA lookup. Enable it when large PSA tables exhaust the memory available to the lookup on the SSIS host.

Notes​

  • This setting is part of the Staging Persistent settings category.
  • The default value for this setting is N.