GeekInterview.com
Series: Subject: Topic:
Question: 52 of 129

what is data cleaning? how is it done?

Asked by: sahira2000 | Member Since Jan-2006 | Asked on: Oct 2nd, 2006

View all questions by sahira2000

Showing Answers 1 - 5 of 5 Answers
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)

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

Yes  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

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

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

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.