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
What is merge stage?
How do you reject records in a transformer?
Can we use target hash file as a lookup ?
whom do you report?
How to clean the datastage repository?
To see hidden files in LINIX?
Can you explain engine tier in information server?
Triggers,VIEW,Procedures
How rejected rows are managed in datastage?
What are the different common services in datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How can you write parallel routines in datastage PX?
What is orabulk stage?
What are the stages 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