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
Does datastage support slowly changing dimensions ?
Differentiate between Join, Merge and Lookup stage?
Describe routines in datastage? Enlist various types of routines.
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What are stage variables and constants?
What are some prerequisites for datastage?
What is the difference between Datastage 7.5 and 7.0?
Explain how a source file is populated?
Give an idea of system variables.
What is the difference between hashfile and sequential file?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is ds designer?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is oci?