June 2007
Beginner to intermediate
480 pages
12h 30m
English
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 ...
Read now
Unlock full access