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
- 9292 Views
- I also Faced
- E-Mail Answers
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
Demonstrate experience in maintaining quality process standards?
How you Implemented SCD Type 1 & Type 2 in your project?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
How do you register plug-ins?
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.
What is the difference between datastage and informatica?
What all the types of jobs you developed?
how to delete one row in target dataset
What are the main differences you have observed between 7.x and 8.x version of datastage?
Difference between server jobs & parallel jobs?
options available in sequence job to run,validate?
What are the different common services in datastage?
What are the different kinds of views available in a datastage director?
How do you import and export the datastage jobs?
How do you schedule or monitoring the job?
