Loading a Data Warehouse in SSIS

Summary:

In this session, you’ll learn how to load a data warehouse using SQL Server Integration Services (SSIS).

We’ll first cover the terminology to be expected when creating and loading a data warehouse.

Then, you’ll learn the benefits and pitfalls of using the Slowly Changing Dimension transform (SCD Wizard) in SSIS and some alternatives to speeding up the load.

Lastly, you’ll learn how to load the fact table and some alternatives to speeding up the load and how Task Factory can speed up data warehouse loads.

Interested in additional SentryOne webinars? Check our webinar library.

Available On Demand

Brian Knight

Founder, Pragmatic Works

Brian Knight is the owner and founder of Pragmatic Works and is a member of the SentryOne advisory board. Brian is a contributing columnist at several technical magazines and does regular webcasts. He is the author of more than fifteen technical books. Brian has spoken at dozens of conferences like PASS, SQL Connections, and TechEd and many Code Camps. He has receiveda number ofawards from the state, governor, and press, including the Business Ambassador Award (Governor) and Top CEO (Jacksonville Magazine). He is on the board of the region’s Chamber of Commerce and Economic Development Corporation.

Chris Cushman

Technical Specialist, SentryOne

Chris Cushman is a Technical Specialist at SentryOne, working with SQL Server Integration Services. He supports customers on connecting to a verity of services and APIs, troubleshooting issues, setup/configuration of SentryOne software, writing articles for the SentryOne Product Knowledge Base, testing software builds, and assisting with certified training.

Webinar: