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
- 11109 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
Define Merge?
What are the differences between datastage and informatica?
Name the command line functions to import and export the DS jobs?
Define APT_CONFIG in Datastage?
Highlight the main features of datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the types of containers?
What are the difference types of stages?
What are the primary usages of datastage tool?
Explain entity, attribute and relationship in datastage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Where do the datastage jobs get stored?
What is the difference between orabulk and bcp stages?
Explain the importance of surrogate key in data warehousing?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
