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 72
Page 137
For including data from outside sources , you will have to create temporary files to hold the data received from the outside sources . After reformatting and rearranging the data el- ements , you will have to move the data to the ...
For including data from outside sources , you will have to create temporary files to hold the data received from the outside sources . After reformatting and rearranging the data el- ements , you will have to move the data to the ...
Page 138
Create intermediary files to store selected data to be merged later • Transport extracted files from multiple platforms • Provide automated job control services for creating extract files • Reformat input from outside sources • Reformat ...
Create intermediary files to store selected data to be merged later • Transport extracted files from multiple platforms • Provide automated job control services for creating extract files • Reformat input from outside sources • Reformat ...
Page 195
File layouts and field definitions for data from outside sources • Other sources such as spreadsheets and manual lists ... Definitions of fields selected for extraction • Criteria for merging into initial extract files on each platform ...
File layouts and field definitions for data from outside sources • Other sources such as spreadsheets and manual lists ... Definitions of fields selected for extraction • Criteria for merging into initial extract files on each platform ...
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 |
Trends in Data Warehousing | 39 |
Copyright | |
30 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 building changes chapter cleansing complex components consider contain cost 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 fact table field Figure files functions important indexes individual information delivery initial integration load look major marketing measurements metadata methods month Name OLAP operational systems options performance platform problem queries records relational reports represent requirements rows rules selection shows single source systems specific standard STAR schema step storage structures summary techniques tion transaction types users values various vendors