We are using LEFT and RIGHT TRIM function in transform stage.

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

5 Answers
9103 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

Please Help Members By Posting Answers For Below Questions

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3736

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

1092

How a source file is populated?

1020

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2213

Describe routines in datastage? Enlist various types of routines.

954

What are transforms and what is the differenece between routines and transforms?

1003

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2167

On which Dimension Table you implemented SCD Type in your Project

1971

What could be a data source system?

942

what is the use of materialized view?

1489

how do u catch bad rows from OCI stage? And what CLI stands for?

2751

What are the different type of jobs in datastage?

1002

What are the different options associated with dsjob command?

1372

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2182

Differentiate between data file and descriptor file?

989