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.
Answer Posted / prasu
right(str(0,3)':'source data),6)
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How do you remove duplicate values in datastage?
How can you write parallel routines in datastage PX?
What is oci?
How to find value from a column in a dataset?
describe the Steps to confiure a Qlogic switch
What are routines in datastage? Enlist various types of routines.
Triggers,VIEW,Procedures
What is the use of datastage director?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
how to write server Routine coding?
What is the difference between operational data stage (ods) and data warehouse?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is difference between server jobs & parallel jobs?
What is the different type of jobs in datastage?
How can one find bugs in job sequence?