O'Reilly logo

The Data Warehouse Lifecycle Toolkit by Bob Becker, Joy Mundy, Warren Thornthwaite, Margy Ross, Ralph Kimball

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Program/Project Management
BI
Application
Development
Physical
Design
ETL
Design &
Development
Dimensional
Modeling
Product
Selection &
Installation
Business
Requirements
Definition
Technical
Architecture
Design
Program/
Project
Planning
Deployment
Growth
Maintenance
BI
Application
Design
CHAPTER 10
Designing and
Developing the ETL
System
T
he process of developing the extract, transformation, and load (ETL)
system is the iceberg of the DW/BI project. So many challenges are buried
in the data sources that developing the ETL application invariably takes more
time than you expect. This chapter is structured as a ten-step plan for creating
the data warehouse’s ETL system. The concepts and approach described in
this chapter apply to systems based on an ETL tool, as well as hand coded

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required