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 / usha

Data cleansing means removing unwanted spaces.
By using LTRim,Rtrim functions we can remove unwanted space

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Whats difference betweeen operational data stage (ods) and data warehouse?

1118


What is the purpose of pivot stage?

1172


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

1086


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2188


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3461


How to convert RGB Value to Hexadecimal values in datastage?

4001


What are the types of containers?

1239


What is the purpose of pivot stage and types of containers in datastage

1042


What are orabulk and bcp stages?

1129


How to perform incremental load in datastage?

1209


What is the differentiate between data file and descriptor file?

1366


Explain the situation where you have applied SCD in your project?

2041


Which commands are used to import and export the datastage jobs?

1414


Define meta stage?

1207


How do you remove duplicate values in datastage?

1155