O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

There's more...

There are some options that are very useful while working with the Lookup Transform; using them will help use the Lookup Transform to its full potential with improved performance in most situations. The next two options reveal these advanced properties.

Cache mode

As Lookup Transform looks for every record from source input inside the reference table, there should be performance tweaks to use during this lookup. SSIS provides a way to use the Cache option and cache the lookup table.

There are three options in the General tab of the Lookup Transform Editor's Cache mode setting:

  • Full Cache: The lookup table will be fully loaded in the cache memory.
  • This option will be optimal if the lookup table is not very large.
  • Partial Cache: The lookup ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required