Data cleansing is the method of detecting or correcting the incorrect data or records from database. Data Cleansing is also referred as Data Scrubbing.
After cleansing, the data will be reliable with other similar data sets in the system. Data cleansing service varies from data validation in that validation almost invariably means data is rejected from the system at entry and is performed at entry time, rather than on batches of data.
The definite process of data cleansing engage remove typographical errors or validating and correcting values against a known list of entities. Data cleansing is very important in maintaining accurate data records and the efficiency of any data dependent business. In case, there is no accurate information within a set of records for instance when it is wrong phone numbers then the other person cannot easily contact them. If the email addresses are not formatted correctly then the automated email system will not be able to send out the latest coupons and special offers. The job of data cleansing is to ensure that the data is accurate and error free.
When data are stored in large volumes, errors are bound to creep into the system. The compilation of a huge database will have the same record entered more than once thereby the same information being repeated and creating duplicates. Multiple entries of these data create duplicates. With the help of an error correction technique, an error is corrected thereby removing inaccurate and invalid entries. The goal of data cleansing is to reduce these errors, and to make the data error free, accurate and useful data Every block of data received is checked and if the check fails the data is retransmitted repeatedly for cleansing, until the data has no or less errors.
Tags: Add new tag
October 10th, 2011 at 10:10 pm
What a great resource!