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

Is possible to create skid in dim,fact tables?

2587


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3130


What are the steps needed to create a simple basic datastage job?

1160


Triggers,VIEW,Procedures

1175


What is the purpose of interprocessor stage in server jobs?

2168


What are the important features of datastage?

1048


Different ways a project can be moved to production ?...example ….export-import and Version control.

2387


Can you highlight the main features of ibm infosphere information server?

1044


What is the project in datastage?

1046


What are the components of datastage?

1063


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

3415


How you can fix the truncated data error in datastage?

1674


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1295


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

2005


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1684