Articles: Data Staging and Data Quality
Is Hand-Coded ETL the Way to Go? (5/31/2003)
by Gary Nissen (edited by Ralph Kimball)
Absolutely yes, or absolutely no, depending...

Doing the Work at Extract Time (2/21/2002)
Countering the minimalist approach; investing in ETL to make querying easier

Brace for Incoming by Warren Thornthwaite (8/31/2001)
Importing external data deserves its own full design and development life cycle

Joint Effort (5/24/2001)
Administer the distributed data warehouse correctly or lose it! The roles of the dimension authority and the local fact table provider

Close the Loop by Steve Tracy (3/27/2001)
Integrate your warehouse with your operational systems before you are overrun

Is Your Data Correct? (12/5/2000)
Simple statistical techniques can help you ensure that users have accurate information at their fingertips

Backward in Time (9/29/2000)
Stitching late-arriving records into an existing data warehouse; Late arriving fact records and late arriving dimension records

Indicators of Quality (4/10/2000)
Use your standard query tools to track data quality and lineage; The audit dimension

Is Data Staging Relational? (4/1998)
Or does it have more to do with sequential processing?

Meta Meta Data Data (3/1998)
Making a list of data about metadata and exploring information cataloging tools

The Operational Data Warehouse (1/1998)
It needs both a transaction version of data and a periodic snapshot version of data

Relocating the ODS (12/1997)
Moving the operational data store will solve a number of problems

Letting the Users Sleep, Part 2 (1/1997)
Nine decision in the design of a data warehouse

Letting the Users Sleep, Part 1 (12/1996)
Nine decision in the design of a data warehouse

Dealing with Dirty Data (9/1996)
The science of maintaining clean data in your warehouse, and why nobody talks about it (Feature Article)

Mastering Data Extraction (6/1996)
Steps you must complete when migrating legacy data into a data warehouse

Automating Data Extraction (6/1996)
Ralph reviews Carleton Passport, ETI Extract, and Prism Warehouse Manager