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
- 13377 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / venkata ramana
Input Seq file:
CodeName
AB1
Aim2
Abnv5
1An8bx
Note: Column(CodeName) lenth is 6
Seq-->Transformar--DataSet
Trasformar:-
In Derivation cell:
Str('0',6 - Len(DSLink3.CodeName)):DSLink3.CodeName
Out put Dataset:-
000AB1
00Aim2
0Abnv5
1An8bx
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What can we do with datastage director?
What is the difference between hashfile and sequential file?
Where do the datastage jobs get stored?
What are the some differences between 7.x and 8.x version of datastage?
What is the difference between validated and compiled in the datastage?
What are the difference types of stages?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is the method of removing duplicates, without the remove duplicate stage?
What are the features of datastage flow designer?
What is ibm datastage?
What is the project in datastage?
How to Remove Duplicate using SQL?
Name the third party tools that can be used in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
