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
- 9310 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 LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
How to read multiple files using a single datastage job if files have the same metadata?
job locking methods? How can we unlock the job?
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
If the job aborted in a sequencer, how can we start that from the previews successful job.
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
What is the purpose of interprocessor stage in server jobs?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
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
Teradata 
