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
- 12968 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
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What all are the different way to run a job?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is the different type of jobs in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Explain ibm infosphere information server and highlight its main features?
Define Data Stage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the types of containers?
Difference between in process and inter process?
What is meta stage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Difference between data warehousing and olap?
