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
- 13383 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
CHANGE CAPTURE
What are iconv and oconv?
What are datastage sequences?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the main features of datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Describe routines in datastage? Enlist various types of routines.
describe the Steps to confiure a Qlogic switch
To see hidden files in LINIX?
Distinguish between informatica & datastage. Which one would you choose and why?
what is the use of materialized view?
What is process model?
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
EXPLAIN SCD
What is difference between join, merge and lookup stage?
