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 / subbuchamala
In the Output Column Derivation of Transformer Stage:
1. Way:
Str('0',6-Len(string)): Input_Col--->Output_Col
2. Way:
right("000000" : Input_Col),6) --->Output_Col
3. Way:
Right(Str("0",6) : Input_Col),6) --->Output_Col
Right(Str("0",3) : Input_Col),6) --->Output_Col
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many areas for files does datastage have?
how to delete one row in target dataset
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is oci?
What is a folder? Difference types of stages?
Where the datastage stored his repository?
Is possible to create skid in dim,fact tables?
project Steps,hits, Project level HArd things,Solved methods?
How we can covert server job to a parallel job?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Why fact table is in normal form?
table actions available in oracle connector?
how do u catch bad rows from OCI stage? And what CLI stands for?
Name the third party tools that can be used in datastage?
How you can fix the truncated data error in datastage?