Sunday, June 14, 2009

Data Quality Process

Profiling (Identifying data quality issues).
Generalized Cleansing (tests to meet business rules).
Parsing and standardization (restructing data into a common format).
Matching (finding unique identifiers and performint de-duplication).
Enrichment (phone and email validation)
Monitoring (checking conformance to data quality requirements).

----------------------------------------------------------------------------------------

The construction of data warehouses involves data cleaning, data integration, and data transformation.

OLAP operations such as roll-up, drill-down, slicing, and dicing.

A data warehouse is a subject-oriented, integrated, time-variant, and nonvolatile collection of data in support of management’s decision making process

-----------------------------------------------------------------------------------------

No comments: