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 / deepak patel
Hey,
You can simply draw output link to next outfile and set column name Datatype varchar and size to 6 and in output file you will get desired output.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the difference between passive stage and active stage?
how to delete one row in target dataset
What are the main features of datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What are the differences between datastage and informatica?
What are the benefits of datastage?
What are sequencers?
Describe the main features of datastage?
Differentiate between Join, Merge and Lookup stage?
What is orabulk stage?
How to read the length of word in unix?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How to reverse the string using unix?
What is size of a transaction and an array means in a datastage?