June 2007
Beginner to intermediate
480 pages
12h 30m
English
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 ...
Read now
Unlock full access