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:

If a piece of information traverses several applications before placement in the DW is the data quality of that information more in question than data that arrives directly from the operational source? If so, is there research that supports this?

A:

Adrienne Tannenbaum?s Answer: Yes, it depends on how much tracking and documentation is available showing what happens to the data on the way ? data flows, meta data flows. Common sense ... if no one knows how something got there or where it came from, I would question data quality.

Chuck Kelley’s Answer: I don’t think so. Each DW field/element/column has a system of record. That system of record is the place that is discovered to hold the most correct data. So if you have several operational sources that have customer, only one will be chosen as the system of record. That doesn’t mean that you won’t take data from the others, but that the system of record is the driver. I think if you look at what Bill Inmon has written in Building the Data Warehouse, you will find that he discusses the system of record sufficiently to be that authoritative source. Of course, you could probably use anyone from the "Ask the Experts" panel.

Clay Rehm’s Answer: This is a great question! From a data quality standpoint, every piece of data that comes into the DW must be questioned no matter how many applications it has traversed. So if that piece of data has had more transformations or more "transports," then you are correct in having more suspicion of that data.

(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.