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 / 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 is the use of datastage director?
What is the use of datastage designer?
What is the process of killing a job in datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is a quality stage in datastage tool?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is "fatal error/rdbms code 3996" error?
Define data aggregation?
Have you have ever worked in unix environment and why it is useful in datastage?
What is the command line function to import and export the ds jobs?
What is the importance of the exception activity in datastage?
How to clean the datastage repository?
How you can fix the truncated data error in datastage?
project Steps,hits, Project level HArd things,Solved methods?
What is the difference between an operational datastage and a data warehouse?