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


Please Help Members By Posting Answers For Below Questions

What is merge stage?

754


How do you reject records in a transformer?

620


Can we use target hash file as a lookup ?

2806


whom do you report?

1494


How to clean the datastage repository?

686






To see hidden files in LINIX?

939


Can you explain engine tier in information server?

643


Triggers,VIEW,Procedures

786


How rejected rows are managed in datastage?

909


What are the different common services in datastage?

693


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

1910


How can you write parallel routines in datastage PX?

609


What is orabulk stage?

619


What are the stages in datastage?

628


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

2002