Interested to Buy Any Domain ? << Click Here >> for more details...
how to cleansing data
- 6 Answers
- 17066 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 to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What is the difference between Datastage 7.5 and 7.0?
In one project how many shared containers are created?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
how can u find out the datastage job is running on how many nodes
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
How can you write parallel routines in datastage PX?
i have flat file and using unix how can i generate sequence number into targer?
what is the Difference Between Datastage Server Edition and Parallel Edition?
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
what is the use of surogate key in datastage
Teradata 
