How can we do data cleaning?



How can we do data cleaning?..

Answer / Sharvan Kumar

To perform data cleaning, you may follow these steps:
1. Removing duplicates
2. Handling missing values (imputation or deletion)
3. Removing outliers
4. Converting categorical data to numerical
5. Standardizing the format of dates and times
6. Correcting errors in spelling or syntax

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

What is VLDB?

1 Answers  


Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

1 Answers  


Explain what are the different methods of loading dimension tables?

1 Answers  


Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

1 Answers   SingleTusk,


What is IQD file?

1 Answers  


What are necessary tasks to install reportnet software?

1 Answers  


What is the definition of cube in datawarehousing?

1 Answers  


What is metadata in context of a datawarehouse?

1 Answers  


Can we take backup when the database is opened?

1 Answers  


Explain what is data validation strategies for data mart validation after loading process?

1 Answers  


How can you set the client management?

1 Answers  


Why do we use DSS database for OLAP tools?

3 Answers  


Categories