Suppose take my name "Reddyvaraprasad"
From source it is coming Reddy vara prasad
Need to get As Reddyvara prasad/
Answer Posted / ambi
select Replace('Reddyvaraprasad','vara','vara ')
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
Name the command line functions to import and export the DS jobs?
How to Remove Duplicate using SQL?
Define project in datastage?
What all the types of jobs you developed?
What is the difference between server job and parallel jobs?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is difference between symmetric multiprocessing and massive parallel processing?
How do you import and export data into datastage?
What is the use of datastage director?
Differentiate between Join, Merge and Lookup stage?
What are the job parameters?
How a routine is called in datastage job?
What is difference between join, merge and lookup stage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What a datastage macro?