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
- 10393 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
How many areas for files does datastage have?
What are the different type of jobs in datastage?
Could anyone give brief explanation bout datastage admin
What are the processing stages?
How to read the length of word in unix?
What are stage variables, derivations and constants?
What are datastage sequences?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
root tree will find which is server job and which is parallel job?
Difference between sequential file and data set?
Does datastage support slowly changing dimensions ?
How to find value from a column in a dataset?
What are the primary usages of datastage tool?
How one source columns or rows to be loaded in to two different tables?
How to RD using transformer?
