Скачать или смотреть SSIS Tutorial Part 66-How to Load Lookup Data Parallel in SSIS Package(Cache Transformation)

SSIS Tutorial for Cache Transformation in SSIS Package
In this video we will learn how Lookup Transformations work in sequence to load the data into memory by performing a demo.

In second part of demo , we will learn how to use the Cache Transformations to load Lookup Data to Memory parallel and then use those Cache Transformation connection managers in the Lookup Transformations.

In scenarios where we have to use multiple lookup Transformations in Data Flow Task and those look up Transformation can take long time to load data on pre execution as they load data into memory one after one.

By using Cache Transformations, we can read data from multiple sources in parallel and then load into Memory so we can make use of Cache Transformations in other Data Flow Tasks and avoid sequential loading of Lookup data into memory.


Link to the blog post for this video with script if used
http://sqlage.blogspot.com/2015/05/ho...


To follow Step by Step SQL Server Integration Services(SSIS) Video Tutorial By TechBrothers, please open below link.
http://www.techbrothersit.com/2014/12...