Cache small lookup tables.
Increase performance by caching small lookup tables.
Use a persistent lookup cache for static lookup tables.
If the lookup table does not change between sessions, configure the Lookup transformation to use a persistent lookup cache. the Integration Service saves and reuses cache files, eliminating the time required to read the lookup table.