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
- 10787 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 is meta stage?
Why do you need stage variables?
Describe routines in datastage? Enlist various types of routines.
What is a datastage job?
Lookup constraints
What are the types of hashed files in data stage
What is the method of removing duplicates, without the remove duplicate stage?
I have a few records just I want to store data in to targets cycling way how?
CHANGE CAPTURE
What are orabulk and bcp stages?
On which interface you will be working as a developer?
How to reverse the string using SQL?
What are the components of ascential data stage?
What can we do with datastage director?
What is the roundrobin collector?
