You can create a connected or unconnected Lookup transformation.

You can create a connected cached lookup or unconnected cached lookup. When you create a cached lookup, the performance increases because the Integration Service caches a large lookup source or small lookup tables. When you cache the lookup source, the Integration Service queries the lookup cache instead of querying the lookup source for each input row.