Chapter 17. Microsoft SQL Server 2008 Integration Services Packages in Business Intelligence Solutions
In this chapter, we turn our attention to the specific implementation details for packages. We’ll look at SSIS extract, transform, and load (ETL) as it applies to OLAP cubes and data mining structures.
ETL for Business Intelligence
As mentioned earlier, you need to load two fundamentally different types of structures via SSIS ETL processes in BI projects: OLAP cubes and data mining structures. Within each of these types of SSAS objects you’ll find a further top-level subset of functionality: the ETL for both the initial structure load (initial cube load, for example) and also for subsequent, regular updates to these structures. These situations ...
Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 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.
