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
Differentiate between validated and Compiled in the Datastage?
Define Merge?
how to implement scd2 in datastage 7.5 with lookup stage
What is meta stage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Where the datastage stored his repository?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is aggtorec restructure operator?
Differentiate between odbc and drs stage?
What steps should be taken to improve Datastage jobs?
describe the Steps to confiure a Qlogic switch
What are the different types of lookups in datastage?
What is the method of removing duplicates, without the remove duplicate stage?
What is difference between join, merge and lookup stage?
What are the different common services in datastage?