i have input like this
Column 1 ,column 2
3,a
4,b
5.c
i want output
aaa
bbbb
ccccc
Ple help any one?
Answer Posted / subbuchamala
Ex:
Str( "a", 3)---->aaa
Str( "b", 4)---->bbbb
Solution:
use below transformer Logic in Output Col Derivation:
Str(DSLink2.col2, DSLink2.Col1)--->Output_Col(Output Column)
Output:
Output_Col
aaa
bbbb
ccccc
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the benefits of datastage?
how can we create rank using datastage?what is the meaning of rank?
What is datastage engine?
What are the types of hashed files in data stage
Explain ibm infosphere information server and highlight its main features?
How do y read Sequential file from job control?
What are the various kinds of containers available in datastage?
How complex jobs are implemented in datstage to improve performance?
Which warehouse using in your datawarehouse
AGGREGATOR default datatype
What is a folder? Difference types of stages?
What are the repository tables in datastage?
Describe routines in datastage? Enlist various types of routines.
What are the functionalities of link partitioner?
What are system variables and sequencers in datastage