O'Reilly logo

Practical Business Intelligence: with SQL Server 2005 by Roger Toren, John C. Hancock

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

Chapter 4. Building a Data Integration Process

It is easy to see the potential benefits of having a well-designed data warehouse that provides a single, consistent view of the information in a business. However, in today’s business world, rapid growth, acquisitions, and mergers lead to multiple source systems and different ways of representing information within most businesses. Before we can reach the goal of a consistent data warehouse, we need to bring together the many different data sources that contain all your business data.

In this phase of developing your Business Intelligence (BI) solution, your task is to populate the dimension and fact tables in your data warehouse. Integrating all your data sources into the data warehouse ...

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