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
how many rows sorted in sort stage by default in server jobs
How many types of views are there in a datastage director?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How many areas for files does datastage have?
how to abort the job its matain duplicates?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is ds designer?
How many types of hash files are there?
what are the devoleper roles in real time? plz tell i am new to datastage....
whom do you report?
How do you register plug-ins?
How do you import and export the datastage jobs?
What is the precedence of stage variables,derivations, and constraints?
What is the purpose of pivot stage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?