Chapter 12. Data Warehouse Concepts
After completing this chapter, you will be able to:
Learn the objectives and characteristics of a functional data warehouse.
Learn the goals of a business intelligence solution.
Distinguish the differences between operational and decision support systems.
Understand the role of data granularity in data warehouse design.
Define facts, aggregations, and dimensions.
Discuss proper assessment of data quality, update frequency, and persistence.
Review ETL architecture options.
Microsoft SQL Server Integration Services (SSIS) will support many different types of database solutions. You might find SSIS useful to import spreadsheet data into your customer management system or to combine invoice records into a central billing ...
Get Microsoft® SQL Server™ 2005 Integration Services Step by Step 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.
