Use the Cache transform for faster look-ups in SSIS

Опубликовано: 04 Ноябрь 2024
на канале: Kahan Data Solutions

4,159

Get my Modern Data Essentials training (for free) & start building more reliable data architectures
https://www.ModernDataCommunity.com

-----

The Cache Transform transformation generates a reference dataset for the Lookup Transformation by writing data from a connected data source in the data flow to a Cache connection manager. The Lookup transformation performs lookups by joining data in input columns from a connected data source with columns in the reference database.

In this video, we will walk through the process of adding a Cache transform to a package and then reference it in a future lookup transform.

Timestamps:
0:00 - Intro
0:06 Add a Cache Transform
2:33 Add a Lookup Transform
3:39 Review Cache Modes
4:25 Complete Lookup Transform
5:56 Closing

Title & Tags:
Implement a Cache Transform in SSIS | SQL Server Integration Services (SSIS) Tutorial
#kahandatasolutions #ssis #dataengineering