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
- 10636 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
Difference between sequential file and data set?
What are the different options associated with dsjob command?
What is job control?
What is quality stage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is the difference between an operational datastage and a data warehouse?
Can we use target hash file as a lookup ?
What are the main features of datastage?
How to RD using transformer?
Can you define merge?
How can we improve performance of data stage jobs?
What is merge stage?
What is the difference between informatica and datastage?
What are the various kinds of containers available in datastage?
How a server job can be converted to a parallel job?
