Interested to Buy Any Domain ? << Click Here >> for more details...
how to cleansing data
- 6 Answers
- 17295 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 |
how many stages are there in Datastage... Please clarify mee??
What is a ds designer?
HOW CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
What are system variables and sequencers in datastage
What is difference between join, merge and lookup stage?
What are the partitioning techniques available in link partitioner?
What is ibm datastage?
How we can covert server job to a parallel job?
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
what is the use of skid in reporting?
Teradata 
