Chapter 13. Populating Data Warehouse Structures
After completing this chapter, you will be able to:
Understand the role of SSIS in maintaining data warehouse models.
Know when and how to implement staging tables.
Use SSIS for loading dimension tables.
Use SSIS for loading fact tables.
Microsoft SQL Server 2005 Integration Services (SSIS) provides a rich set of built-in tasks, containers, transformations, and data adapters that support the development of business applications. Without writing a single line of code, you can create SSIS solutions that solve complex business problems, using extract, transform, and load (ETL) and business intelligence (BI) processes to manage SQL Server databases.
You learned in Chapter 12, how a data warehouse is often ...
Get Microsoft® SQL Server™ 2005 Integration Services Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
