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
Define Data Stage?
What are the types of containers in datastage?
Why fact table is in normal form?
How to manage date conversion in Datastage?
Can you explain players in datastage?
How we can covert server job to a parallel job?
What is aggtorec restructure operator?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Can you highlight the main features of ibm infosphere information server?
How you can fix the truncated data error in datastage?
What are the types of hashed files in data stage
What is the importance of the exception activity in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is the sortmerge collector?