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 a datastage job?
What are the differences between datastage and informatica?
What is the importance of the exception activity in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is a merge?
What could be a data source system?
What is "fatal error/rdbms code 3996" error?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What are the different kinds of views available in a datastage director?
Why do we use link partitioner and link collector in datastage?
what is use of SDR function?
How to RD using transformer?
What is datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are iconv and oconv?