Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Suppose take my name "Reddyvaraprasad"

From source it is coming Reddy vara prasad

Need to get As Reddyvara prasad/

Answers were Sorted based on User's Feedback



Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad ..

Answer / akila

Create 3 stage variables to split the name into three and
then concatenate

SV1 = Field(NAME," ",1)
SV2 = Field(NAME," ",2)
SV3 = Field(NAME," ",3)

Then concatenate in the column derivation as sv1:sv2:" ":sv3

Is This Answer Correct ?    8 Yes 1 No

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad ..

Answer / hussy

I am sowwie akila. tat was the correct answer mistakenly I
have clicked on the other option. hope u dont mind

Is This Answer Correct ?    0 Yes 0 No

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad ..

Answer / vaibhav

Hi Akila,

What if input name comes as Ajay Rathore... Surname should be differentiated with space and middle name should be concatenated with first name...then this solution might be wrong...

Is This Answer Correct ?    0 Yes 0 No

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad ..

Answer / ambi

select Replace('Reddyvaraprasad','vara','vara ')

Is This Answer Correct ?    5 Yes 6 No

Post New Answer



More Data Stage Interview Questions

What is RCP

5 Answers   CGI, CTS,


what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,


what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?

4 Answers   HCL,


how does work server jobs?

1 Answers  


What is the importance of the exception activity in datastage?

0 Answers  






in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

0 Answers   IBM,


HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,


what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,


how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,


which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

2 Answers   TIAA CREF,


how to handle null values using transformer stage?

1 Answers  


what is the use of invokation id

2 Answers   IBM,






Categories