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
- 9102 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 to implement complex jobs in data stage?
How to initialize environment variables?
how to design the change capture stage in(data stage parallel jobs) type 2
What is apt_config in datastage?
how can we create tables in datastage?
What is container and then types?
i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?
if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
17 Answers IBM, TCS,
in oracle target stage when we use load option and when we use upsert option?
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
what is repositery?
Teradata 
