Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

How to Perform Data Cleaning and Preprocessing?

Question Posted / hr@tgksolutions.com


How to Perform Data Cleaning and Preprocessing?..

Answer / hr@tgksolutions.com

Several steps may be involved in SQL data cleaning and preprocessing:

Use the ROW_NUMBER() window function or the DISTINCT keyword to eliminate duplicates.
Managing missing values: To replace NULL values, use functions such as COALESCE.
Use the CAST or CONVERT functions to fix data types.
Utilize string functions like as LOWER, UPPER, TRIM, and others to standardize formats.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

What is meant by a database?

0 Answers  

What are the uses of database management system?

0 Answers  

wat is meant by oracle

3 Answers   Infosys,

What are the steps in creating a database?

0 Answers  

I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?

1 Answers   eBay, Google,

how can we restore RMAN backup from SUN O/S to AIX 5.3? is it possible or not?

1 Answers   Satyam,

What is oracle block? Can two oracle blocks have the same address?

0 Answers  

What is cardinality in db?

0 Answers  

What is order by clause?

0 Answers  

What are the various types of relationships in database? Define them.

0 Answers  

Why does reading require write privileges on database file?

0 Answers  

List few disadvantages of file processing system.

0 Answers  

For more Database Management Interview Questions Click Here
Categories