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

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2112


What is the difference between server job and parallel jobs?

754


why do u need the IOS upgradation in a FC switch

1933


What are orabulk and bcp stages?

717


Nls stands for what in datastage?

809






Difference between data warehousing and olap?

716


What is ibm datastage flow designer?

761


What are the different options associated with dsjob command?

1054


what is the custome stage in datastage? how can we impliment that one? plz tell me

1976


What are the types of containers?

773


Name the third party tools that can be used in datastage?

694


How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1146


How to RD using transformer?

937


How to manage date conversion in Datastage?

709


What are the areas of application?

752