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
- 9463 Views
- I also Faced
- E-Mail Answers
Answer Posted / balu
We are using LEFT and RIGHT TRIM function in transform stage.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you write parallel routines in datastage PX?
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?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Define ds designer?
What is the difference between orabulk and bcp stages?
How a server job can be converted to a parallel job?
What is staging variable?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is size of a transaction and an array means in a datastage?
How to RD using transformer?
What are the partitioning techniques available in link partitioner?
why do u need the IOS upgradation in a FC switch
What are the areas of application?
Difference between in process and inter process?
client know skid info?
