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

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2330

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

1077

Is the value of staging variable stored temporarily or permanently?

1052

What are the functionalities of link partitioner?

1064

Difference between data warehousing and olap?

1140

What are stage variables?

1252

What are the primary usages of datastage tool?

1128

Have you used Unstructured data?

1368

what is the use of surogate key in datastage

2364

What is the importance of the exception activity in datastage?

1111

Define APT_CONFIG in Datastage?

1135

What is the difference between validated and compiled in the datastage?

1369

What are stage variables and constants?

1193

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3401

What is the difference between passive stage and active stage?

1642