Problems In Building a Data Warehouse

Building a data warehouse usually isn't a small project, but somehow management sometimes sees it as something that can quickly eb done with a tool or two. Longtime DBA Janet Wong brings us a look at some of the problems you might face when getting ready to embark on this
type of project.

In the Windows world, if you hit the...

Using Data Warehouse for CRM

Usually a data warehouse is used for some sort of Business Intelligence system. Data warehousing experts Vincent Rainardi and Amar Gaddam bring us another great article on warehousing with a look at how a warehouse might be used for a CRM system.

What's an allocation unit?

Populating Fact Tables

Part 3 of Vincent Rainardi's data warehousing series looks at some of the situations and challenges of loading a fact table in a data warehouse.

Avoiding the Metadata Pitfalls

By doing a bit of groundwork and effectively controlling the scope of the metadata repository continuously throughout the project, few problems should arise.

Which of the following is not an allocation...

Kimball University: Four Fixes Refurbish Legacy Data Warehouses

DW/BI professionals are often tasked with making evolutionary upgrades and improvements to minimize cost and upheaval in the current analytic environment. We explore four upgrades that can breathe new life into legacy data warehouses.

Data Warehouse Loading

Data warehousing is becoming more and more popular, especially as companies seek to leverage the information stored in various systems to improve their business processes. Warehousing expert Vincent Rainardi brings us the next installment of his series on data warehousing, examining the issues of loading data.

You have noticed in both your SQL Server...