right(str("0",3):source

My source having following data as below,
AB1
Aim2
Abnv5
1An8bx
and my question is i need the Datastage job the following
as in my target

000AB1
00Aim2
0Abnv5
1An8bx
Please help me to achive this.

Question Posted / reddymkl.dwh

6 Answers
13231 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / reddymkl.dwh

right(str("0",3):source_data,3)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the different type of jobs in datastage?

974

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

3997

How do you register plug-ins?

962

If you want to use a same piece of code in different jobs, how will you achieve this?

1276

Define project in datastage?

1093

How complex jobs are implemented in datstage to improve performance?

1042

What is aggtorec restructure operator?

1452

Name the different types of Lookups in Datastage?

1259

Can you explain link buffering?

1179

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1389

What is the difference between in process and inter process?

1147

What could be a data source system?

1008

Define ds designer?

1278

Where do you see different stages in the designer?

1092

To see hidden files in LINIX?

1529