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 one source columns or rows to be loaded in to two different tables?
Is possible to create skid in dim,fact tables?
Can you explain how could anyone drop the index before loading the data in target in datastage?
options available in sequence job to run,validate?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are the steps needed to create a simple basic datastage job?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the partitioning techniques available in link partitioner?
how can we create rank using datastage?what is the meaning of rank?
Can you filter data in hashed file?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Which algorithm you used for your hashfile?
What are the functionalities of link partitioner and link collector?
How to RD using transformer?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?