Suppose take my name "Reddyvaraprasad"
From source it is coming Reddy vara prasad
Need to get As Reddyvara prasad/
Answer Posted / 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 |
Post New Answer View All Answers
Distinguish between informatica & datastage. Which one would you choose and why?
What is the method of removing duplicates, without the remove duplicate stage?
Explain how a source file is populated?
What steps should be taken to improve Datastage jobs?
what is the difference between == and eq in UNIX shell scripting?
Can you explain repository tables in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are routines in datastage?
how to abort the job its matain duplicates?
what is the use of surogate key in datastage
explain about citrix scheduling tool in datastage
What is the difference between operational data stage (ods) and data warehouse?
Describe stream connector?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Difference between ‘validated ok’ and ‘compiled’ in data stage?