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

How do you generate sequence number in datastage?

1072

How to clean the datastage repository?

1111

How will you move hashed file from one location to another location?

2142

what is use of SDR function?

5159

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2173

What are the different types of lookups in datastage?

1047

Why fact table is in normal form?

1218

What is the method of removing duplicates, without the remove duplicate stage?

1004

How complex jobs are implemented in datstage to improve performance?

1021

What are the job parameters?

1208

Define project in datastage?

1085

Whats difference betweeen operational data stage (ods) and data warehouse?

1102

What is difference between server jobs & parallel jobs?

1024

How you can fix the truncated data error in datastage?

1750

Differentiate between data file and descriptor file?

1033