Use field function in transformer stage. This function performs based on

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

5 Answers
9227 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain usage analysis in datastage?

1147

Why do we use link partitioner and link collector in datastage?

1116

What is quality stage?

976

Differentiate between datastage and datastage tx?

1040

Why we use surrogate key?

1208

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2703

What is a datastage job?

1005

What are the different type of jobs in datastage?

1035

Describe link sort?

994

how many rows sorted in sort stage by default in server jobs

3984

Why do we use exception activity in Datastage?

1288

What are the components of ascential data stage?

1169

What are the repository tables in datastage?

1291

How do you import and export the datastage jobs?

1146

What can we do with datastage director?

1223