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

how to sort two columns in single job in datastage.

2887

How a source file is populated?

1050

what is the use of surogate key in datastage

2300

What are the types of containers and how to create them?

966

What are the types of views in datastage director?

1757

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2603

What is the difference between orabulk and bcp stages?

1016

what are the errors,warnings in datastage

2683

Which commands are used to import and export the datastage jobs?

1408

what is the difference between == and eq in UNIX shell scripting?

1483

What are the functionalities of link partitioner?

1006

Name the command line functions to import and export the DS jobs?

1140

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3242

What is the different type of jobs in datastage?

954

What are stage variables and constants?

1138