O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding ETL

ETL, in a BI project context, is the process of preparing all source data for use in an OLAP cube. The rich SSIS toolset can also be used for other types of data movement, for example, data consolidations and migrations. In this book we will focus on the BI project use of SSIS, which is extracting, transforming, and loading data from one or more source systems into an OLAP model. This process may also involve the use of an intermediate staging server that contains a staging database with staging tables. The use of a staging server and database is usually driven by the complexity and messiness of the source data. For example, in a recent project we worked on, there were 16 data sources, each with its own unique validation issues. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required