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
13144 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?

1097

What is a quality stage in datastage tool?

1063

Differentiate between odbc and drs stage?

1035

Enlist various types of routines in datastage.

1228

Explain ibm infosphere information server and highlight its main features?

1081

What are the job parameters?

1208

What is datastage?

1069

Why we use surrogate key?

1208

Triggers,VIEW,Procedures

1214

How can you write parallel routines in datastage PX?

1001

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

1102

What is the different type of jobs in datastage?

952

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3739

Can you implement SCD2 using join, transformer and funnel stage?

1534

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2356