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
- 13033 Views
- Wipro, I also Faced
- E-Mail Answers
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
In Datastage, how you can fix the truncated data error?
What are the job parameters?
What is difference between symmetric multiprocessing and massive parallel processing?
How rejected rows are managed in datastage?
To see hidden files in LINIX?
What are the partitioning techniques available in link partitioner?
Enlist various types of routines in datastage.
Explain the importance of surrogate key in data warehousing?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What is datastage?
What are the important features of datastage?
How to Remove Duplicate using SQL?
Can you explain engine tier in information server?
Differentiate between odbc and drs stage?
What could be a data source system?
