use Row splitter as tranform stage and specified the column name.

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...

Question Posted / ashutosh g

5 Answers
9464 Views
I also Faced
E-Mail Answers

Answer Posted / ashutosh g

use Row splitter as tranform stage and specified the column
name.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain entity, attribute and relationship in datastage?

1155

What are the main differences you have observed between 7.x and 8.x version of datastage?

1133

What are stage variables and constants?

1193

Explain ibm infosphere information server and highlight its main features?

1140

what is the use of skid in reporting?

2426

What are routines in datastage?

1380

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2115

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3693

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3181

how to delete one row in target dataset

3166

If you want to use the same piece of code in different jobs, how will you achieve it?

1218

Can you define merge?

1188

Define repository tables in datastage?

1203

What are datastage sequences?

1169

How a routine is called in datastage job?

1162