Kishore
Answered On : Oct 3rd, 2006
I can simply say it as Purifying the data.
Data Cleansing: the act of detecting and removing and/or correcting a databases dirty data (i.e., data that is incorrect, out-of-date, redundant, incomplete, or formatted incorrectly)

1 User has rated as useful.
Login to rate this answer.
data clensing is nothing but standidizing and reformatting ( encoding,decoding,data type conversion) the data before we store the data in the warehouse.

1 User has rated as useful.
Login to rate this answer.
chandra
Answered On : Dec 30th, 2006
it is a process of identifing and changing the inconsistencies and inaccuracies

1 User has rated as useful.
Login to rate this answer.
It is nothing but purifying data , the extract process always exposes the data qulaity issues that have been bured within the operational source system. Since the data qulaity significantly impacts data warehouse credibility , you need to address these qulaity problems during the data staging which is nothing data cleaning.

1 User has rated as useful.
Login to rate this answer.
Gvkishore
Answered On : Jan 16th, 2012
Could you please give me one real time example How we do data cleansing.....
Login to rate this answer.