Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 6 Answers
- 13205 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / prasu
right(str(0,3)':'source data),6)
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is staging variable?
What are the types of views in datastage director?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How can you write parallel routines in datastage PX?
What is datastage engine?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Explain how a source file is populated?
In Datastage, how you can fix the truncated data error?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How you can fix the truncated data error in datastage?
What are the difference types of stages?
What are the types of jobs we have in datastage?
What is size of a transaction and an array means in a datastage?
Name the different types of Lookups in Datastage?
How to read the length of word in unix?
