Interested to Buy Any Domain ? << Click Here >> for more details...
how to cleansing data
- 6 Answers
- 17446 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / navin
Data cleansing means converting non unique data format into unique format .This is performed in Transformer stage.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / 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 |
Answer / 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 |
Answer / krish
it is process of correcting the inconsitency data and make consitent format
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / venkatesh k
Data cleansing means performing all the de-dupe rules according to the requirements and make your data unique.For cleansing operations mainly we will use transformer,sort stage,aggregator and look up.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / b.rambabu
data cleansing is a process of identifing the the data
inconsistency and inaccuracies
ex:
data inaccuracy:
hyd
Hydrabad
after
hydrabad
hydrabad
data inconsistency
10.78
10.23465
after
10.27
10.23
| Is This Answer Correct ? | 1 Yes | 2 No |
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Name the different types of Lookups in Datastage?
What could be a data source system?
Which commands are used to import and export the datastage jobs?
how to abort the job its matain duplicates?
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
Describe link sort?
What are the third party tools you used in your project?
How to transfer file from one system to another system in UNIX?which command to be use?
describe the Steps to confiure a Qlogic switch
how can we extract data with out having any common column
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
Teradata 
