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
- 9461 Views
- I also Faced
- E-Mail Answers
Answer Posted / swamy
Use field function in transformer stage. This function
performs based on delimeter... so, you can use that field
function. like field(delimeter, occurance) - field means
(input column) delimeter ("-") occurance(2) ...
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are the types of jobs we have in datastage?
Difference between server jobs & parallel jobs?
What is difference between server jobs & parallel jobs?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What is the difference between operational data stage (ods) and data warehouse?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How rejected rows are managed in datastage?
What is the project in datastage?
What are the difference types of stages?
how to export or import the jobs in .ISX file
What is the difference between datastage and datastage tx?
What is active and passive stage?
How many types of views are there in a datastage director?
What are the functionalities of link collector?
Different ways a project can be moved to production ?...example ….export-import and Version control.
