August 2017
Beginner to intermediate
426 pages
9h 36m
English
When you create the Lookup transformation, you can configure the lookup transformation to cache the data. Caching the data makes the processing faster since the data is stored internally after the cache is created. Once you select to cache the data, Lookup transformation caches the data from the file or table once, and then, based on the condition defined, lookup sends the output value. Since the data gets stored internally, the processing becomes faster as it does not require checking the lookup condition in the file or database. Integration services query the cache memory as against checking the file or table for fetching the required data.
When you select to create cache, Integration service creates ...
Read now
Unlock full access