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
- 9218 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 are the components of ascential data stage?
What is the roundrobin collector?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the functionalities of link partitioner and link collector?
Why do you need stage variables?
Define Merge?
Describe stream connector?
How to implement complex jobs in data stage?
table actions available in oracle connector?
Define Job control?
What are the important features of datastage?
State the difference between an operational datastage and a data warehouse?
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 ?
How many types of views are there in a datastage director?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
