The Benefits of Integration

We now have designed two data mart structures to serve as the source for Analysis Services cubes. You might have noticed, however, if you look into either of these data marts, that they are completely empty. There is not much business intelligence to be gleaned from an empty data mart!

We need to get data into our data marts. This is done using Integration Services. In the next chapter, we look at the many and varied capabilities of Integration Services. We also develop and utilize some working Integration Services packages to populate our all-too-empty data marts, making them much more useful.

Delivering Business Intelligence with Microsoft SQL Server 2005
Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsofts Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A
ISBN: 0072260904
EAN: 2147483647
Year: 2007
Pages: 112
Authors: Brian Larson

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: