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
- 13379 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
What are the repository tables in datastage?
Can you filter data in hashed file?
describe the Steps to confiure a Qlogic switch
Can you explain link buffering?
How do y read Sequential file from job control?
Explain connectivity between datastage with datasources?
What is the method of removing duplicates, without the remove duplicate stage?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
how to sort two columns in single job in datastage.
What is the difference between operational data stage (ods) and data warehouse?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
To see hidden files in LINIX?
What is the difference between the local container and shared container?
Could anyone give brief explanation bout datastage admin
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
