Suppose take my name "Reddyvaraprasad"
From source it is coming Reddy vara prasad
Need to get As Reddyvara prasad/
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
In Datastage, how you can fix the truncated data error?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How will you move hashed file from one location to another location?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Can you explain tagbatch restructure operator?
What are the job parameters?
What is the roundrobin collector?
how to delete one row in target dataset
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the enhancements made in datastage 7.5 compare with 7.0?
Explain ibm infosphere information server and highlight its main features?
Where the datastage stored his repository?
How do you schedule or monitoring the job?
What is oci?
Differentiate between odbc and drs stage?