Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 5 Answers
- 9291 Views
- I also Faced
- E-Mail Answers
Answer Posted / madan
use substr in transformer and divide it in to 2 fields as
required
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What all are the different way to run a job?
On which Dimension Table you implemented SCD Type in your Project
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
describe the Steps to confiure a Qlogic switch
Explain how a source file is populated?
What is process model?
How one source columns or rows to be loaded in to two different tables?
Define repository tables in datastage?
What is the sortmerge collector?
I have a few records just I want to store data in to targets cycling way how?
What is difference between server jobs & parallel jobs?
How do you generate sequence number in datastage?
what is use of SDR function?
What is difference between join, merge and lookup stage?
What is quality stage?
