use substr in transformer and divide it in to 2 fields as required

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 / madan

5 Answers
9098 Views
I also Faced
E-Mail Answers

Answer Posted / madan

use substr in transformer and divide it in to 2 fields as
required

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How and where you used hash file?

1107

table actions available in oracle connector?

1554

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3412

How to convert RGB Value to Hexadecimal values in datastage?

3926

What are the steps needed to create a simple basic datastage job?

1158

Define APT_CONFIG in Datastage?

1016

Where do you see different stages in the designer?

1034

What are system variables and sequencers in datastage

1067

How to perform incremental load in datastage?

1124

What is job control?

1032

root tree will find which is server job and which is parallel job?

1881

EXPLAIN SCD

1337

What are the features of datastage flow designer?

990

What is the difference between an operational datastage and a data warehouse?

1087

Where do the datastage jobs get stored?

1149