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 / palgun
Simple.....use da delimiter as --
SCH-AS--1010
Does dat solve ur prob??
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How many types of sorting methods are available in datastage?
What is data partitioning?
how to implement scd2 in datastage 7.5 with lookup stage
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is "fatal error/rdbms code 3996" error?
What are data elements?
What are the types of views in datastage director?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Define ds designer?
Differentiate between data file and descriptor file?
What are the different options associated with dsjob command?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
what is the use of surogate key in datastage
How to reverse the string using SQL?
Differentiate between datastage and informatica?