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
- 10567 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 active and passive stage?
What are system variables and sequencers in datastage
Which warehouse using in your datawarehouse
options available in sequence job to run,validate?
how to delete one row in target dataset
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are the functionalities of link collector?
Can you explain repository tables in datastage?
How to RD using transformer?
Differentiate between hash file and sequential file?
How do you import and export the datastage jobs?
Explain how a source file is populated?
What is the different type of jobs in datastage?
How to read multiple files using a single datastage job if files have the same metadata?
How many types of hash files are there?
