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
- 13229 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
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What all the types of jobs you developed?
What are stage variables?
How do y read Sequential file from job control?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are system variables and sequencers in datastage
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Define meta stage?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are the types of containers in datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Where do you see different stages in the designer?
sed,awk,head
What are the components of ascential data stage?
