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

how to cleansing data

Answer Posted / satyanarayana

In this removes the unwanted data(Bad records OR NULL
Values) and find the inconsistent data and make it
consistent data.

Example:

LOc
---
Hyd
Hyderabad
hyde

After Cleansing

Loc
---
Hyderabad
Hyderabad
Hyderabad

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many rows sorted in sort stage by default in server jobs

4047


How many types of views are there in a datastage director?

1336


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2867


How many areas for files does datastage have?

1213


how to abort the job its matain duplicates?

2620


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2109


What is ds designer?

1159


How many types of hash files are there?

1233


what are the devoleper roles in real time? plz tell i am new to datastage....

2212


whom do you report?

1981


How do you register plug-ins?

995


How do you import and export the datastage jobs?

1207


What is the precedence of stage variables,derivations, and constraints?

1123


What is the purpose of pivot stage?

1223


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2223