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
- 12974 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
How to perform incremental load in datastage?
What are transforms and what is the differenece between routines and transforms?
Define orabulk and bcp stages?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How do you import and export data into datastage?
What are the different type of jobs in datastage?
Enlist various types of routines in datastage.
What are the types of jobs we have in datastage?
how to implement scd2 in datastage 7.5 with lookup stage
What are the various kinds of the hash file?
client know skid info?
What are the different kinds of views available in a datastage director?
What is the difference between odbc and drs stage?
What are the functionalities of link partitioner?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
