Hi am sundar, i have datas like
00023-1010
00086-1010
00184F2-1010
.
.
.
.
SCH-AS-1010
200-0196-039
.
.
.
Now i want the result "SCH-AS" in onee column and "1010" in
another column.. Can any one tell the answer...
Answer Posted / balu
We are using LEFT and RIGHT TRIM function in transform stage.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the precedence of stage variables,derivations, and constraints?
What is the difference between hashfile and sequential file?
What is the use of hoursfromtime() function in transformer stage in datastage?
Explain Quality stage?
Can you explain kafka connector?
What is the purpose of pivot stage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the primary usages of datastage tool?
how to write server Routine coding?
What is datastage engine?
Differentiate between hash file and sequential file?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
what are the errors,warnings in datastage
how to abort the job its matain duplicates?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu