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
Which commands are used to import and export the datastage jobs?
table actions available in oracle connector?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Where the datastage stored his repository?
How you Implemented SCD Type 1 & Type 2 in your project?
What are the enhancements made in datastage 7.5 compare with 7.0?
I have a few records just I want to store data in to targets cycling way how?
What are the partitioning techniques available in link partitioner?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the different types of lookups in datastage?
Explain datastage architecture?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Differentiate between Join, Merge and Lookup stage?
What is the difference between passive stage and active stage?