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
- 13140 Views
- Wipro, I also Faced
- E-Mail Answers
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
Name the different sorting methods in datastage.
Have you have ever worked in unix environment and why it is useful in datastage?
How to perform incremental load in datastage?
How a server job can be converted to a parallel job?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Nls stands for what in datastage?
Can you define merge?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the difference between passive stage and active stage?
how to delete one row in target dataset
What is the precedence of stage variables,derivations, and constraints?
What is the purpose of pivot stage and types of containers in datastage
How the ipc stage work?
What are the job parameters?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
