Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search
advertisement

Resource Portals
Business Intelligence
Business Performance Management
Data Integration
Data Quality
Data Warehousing Basics
EAI
EDM
EII
ETL
More Portals...

Advertisement

Information Center
DM Review Home
Conference & Expo
Web Seminars & Archives
Newsletters
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

General Resources
Bookstore
Industry Events Calendar
Vendor Listings
White Paper Library
Glossary
Software Demo Lab
Monthly Product Guides
Buyer's Guide

General Resources
About Us
Press Releases
Awards
Media Kit
Reprints
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Ask the Experts Question and Answer

Ask the Expert

Meet the Experts
Ask a Question (Names of individuals and companies will not be used.)
Question Archive
Ask the Experts Home

Q:  

Do you have any information regarding quality edits and procedures for loading warehouses and verifying data before releasing to the business groups?

A:  

Sid Adelman's Answer: Be sure to verify the data before releasing it to the business groups. Most data warehouses have had data quality problems, and if they are not corrected before the users perform their queries, the data warehouse (and you) will lose credibility. Users often stop writing queries if they believe the data is bad. It takes a long time to restore credibility.

Larissa Moss's Answer: I would like to refer you to the article, "Data Cleansing: A Dichotomy of Data Warehousing" published in DM Review in February, 1998. This article has an extensive discussion of various categories of "dirty data" to be edited. Another series of articles called "Measure Twice - Cut Once," published in DM Review April 1999 (Part I), May 1999 (Part II), June 1999 (Part III) talks in detail about procedures for the ETL (extract/transform/load) process to the data warehouses.

(Posted )


ARCHIVE OF QUESTIONS & ANSWERS FOR DATA QUALITY
BACK TO THE LIST OF CATEGORIES



Advertisement
advertisement
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2005 DM Review and SourceMedia, Inc. All rights reserved.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.