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
- 9226 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / madan
use substr in transformer and divide it in to 2 fields as
required
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ashutosh g
use Row splitter as tranform stage and specified the column
name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / balu
We are using LEFT and RIGHT TRIM function in transform stage.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / palgun
Simple.....use da delimiter as --
SCH-AS--1010
Does dat solve ur prob??
| Is This Answer Correct ? | 0 Yes | 4 No |
how can we extract data with out having any common column
What are the types of jobs we have in datastage?
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
What is use Array size in datastage
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
What are the types of views in datastage director?
Name the different sorting methods in datastage.
What is APT_DUMP_SCORE?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Teradata 
