Data Warehousing Fundamentals: A Comprehensive Guide for IT ProfessionalsGeared to IT professionals eager to get into the all-important field of data warehousing, this book explores all topics needed by those who design and implement data warehouses. Readers will learn about planning requirements, architecture, infrastructure, data preparation, information delivery, implementation, and maintenance. They'll also find a wealth of industry examples garnered from the author's 25 years of experience in designing and implementing databases and data warehouse applications for major corporations. Market: IT Professionals, Consultants. |
From inside the book
Results 1-3 of 93
Page 32
In the separate environment , you may extract the source data into a group of flat
files , or a data - staging relational database , or a combination of both . Data
Transformation . In every system implementation , data conversion is an
important ...
In the separate environment , you may extract the source data into a group of flat
files , or a data - staging relational database , or a combination of both . Data
Transformation . In every system implementation , data conversion is an
important ...
Page 272
Before moving the extracted data from the source systems into the data
warehouse , you inevitably have to perform various kinds of data transformations
. You have to transform the data according to standards because they come from
many ...
Before moving the extracted data from the source systems into the data
warehouse , you inevitably have to perform various kinds of data transformations
. You have to transform the data according to standards because they come from
many ...
Page 278
Source System data changes for dimensions Perform data transformation
functions Perform data cleansing functions Determine type of dimension change
Consolidate and integrate data TYPE 1 TYPE 2 TYPE 3 Convert production key
to ...
Source System data changes for dimensions Perform data transformation
functions Perform data cleansing functions Determine type of dimension change
Consolidate and integrate data TYPE 1 TYPE 2 TYPE 3 Convert production key
to ...
What people are saying - Write a review
We haven't found any reviews in the usual places.
Contents
The Compelling Need for Data Warehousing | 1 |
The Building Blocks | 19 |
Planning and Project Management | 63 |
Copyright | |
14 other sections not shown
Other editions - View all
Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals Paulraj Ponniah Limited preview - 2004 |
Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals Paulraj Ponniah No preview available - 2004 |
Common terms and phrases
able aggregate analysis applications approach architecture attributes build changes chapter cleansing columns complex components consider contain costs create data extraction data marts data mining data quality data structures data transformation data warehouse data warehousing database decision definition dimension table discuss environment example executive fact table Figure files functions important individual information delivery initial integrated load look major marketing metadata methods month Name OLAP operational systems options performance physical platform problem queries records relational reports represent requirements rows schema selection shows single source systems specific standards STAR step storage strategic structures summary techniques tion types users values various vendors ware
Bibliographic information
| Title | Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals |
| Author | Paulraj Ponniah |
| Edition | illustrated |
| Publisher | Wiley, 2001 |
| Original from | the University of Michigan |
| Digitized | 19 Nov 2007 |
| ISBN | 0471412546, 9780471412540 |
| Length | 544 pages |
| Subjects | › › Computers / Databases / Data Warehousing Computers / Information Technology |
| Export Citation | BiBTeX EndNote RefMan |