|
Data Cleansing for datawarehouse |
|
|
|
What is Data Cleansing?
The elevator pitch: "Data cleansing ensures that undecipherable data does not enter the data warehouse. Undecipherable data will affect reports generated from the data warehouse via OLAP, Data Mining and KPI's."
A very simple example of where data cleansing would be utilized is how dates are stored in separate applications. Example: 11th March 2007 can be stored as '03/11/07' or '11/03/07' among other formats. A data warehousing project would require the different date formats to be transformed to a uniform standard before being entered in the data warehouse.
|
This is part of our Data Warehousing Glossary section. Glossary section contains brief note on the frequently used business intelligence related terms. The objective of the Glossary section is to help users to be more specific when they use jargons related to Data Warehousing. You may want to use our SEARCH option to find Detailed Articles related to the topic.
Glossary 
