Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose take my name "Reddyvaraprasad"
From source it is coming Reddy vara prasad
Need to get As Reddyvara prasad/
- 4 Answers
- 10622 Views
- TCS, I also Faced
- E-Mail Answers
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
What are the differences between datastage and informatica?
Can you explain engine tier in information server?
how can we create rank using datastage?what is the meaning of rank?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is usage analysis in datastage?
what is the use of surogate key in datastage
What is the difference between in process and inter process?
Explain ibm infosphere information server and highlight its main features?
What is the purpose of pivot stage and types of containers in datastage
Difference between server jobs & parallel jobs?
What are orabulk and bcp stages?
Define oconv () and iconv () functions in datastage?
What is the importance of the exception activity in datastage?
Name the different sorting methods in datastage.
Describe stream connector?
