Summary:
Building ETL pipelines in SQL Server Integration Services (SSIS) can be difficult and time-consuming. You need to make sure your packages run as efficiently as possible, with the least amount of development effort required.
In this webinar, we’ll examine some common ETL design patterns and how you can address them efficiently both in native SSIS and using SentryOne Task Factory components.
We'll show you how to handle:
- A slowly changing dimension
- Insert and Update into the same target table
- Key lookups when you have complex join conditions
You will learn how to make your SSIS packages run faster when faced with these scenarios, and how to use Task Factory to handle these scenarios with minimal development cost.
Interested in additional SentryOne webinars? Check our webinar library.
Available On Demand
