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 differences between datastage and informatica?
which r the connectors used in san?
How many areas for files does datastage have?
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 a merge in datastage?
How we can covert server job to a parallel job?
What are the repository tables in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
What are stage variables?
Define project in datastage?
How many Key we can define in remove duplicate stage?
What are the different layers in the information server architecture?
Explain ibm infosphere information server and highlight its main features?
what is use of SDR function?
What are the main differences you have observed between 7.x and 8.x version of datastage?