Answer Posted / 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 |
Post New Answer View All Answers
Difference between sequential file and data set?
Define Data Stage?
If you want to use the same piece of code in different jobs, how will you achieve it?
how to export or import the jobs in .ISX file
What is the difference between account and directory options ?
Terminate Activity
how to sort two columns in single job in datastage.
how to implement scd2 in datastage 7.5 with lookup stage
How many types of sorting methods are available in datastage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Differentiate between odbc and drs stage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the purpose of pivot stage?
Nls stands for what in datastage?
What are the different kinds of views available in a datastage director?