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
13206 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 difference between datastage and informatica?

1114

What is the difference between odbc and drs stage?

1091

What is ds designer?

1098

How to clean the datastage repository?

1125

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

2223

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1746

EXPLAIN SCD

1390

How can we improve the performance in datastage?

1100

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2442

Can you define merge?

1118

What is the difference between in process and inter process?

1142

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

1274

Define ds designer?

1275

Can you explain repository tables in datastage?

1403

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1502