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 different layers in the information server architecture?
What is the project in datastage?
Which warehouse using in your datawarehouse
what are the devoleper roles in real time? plz tell i am new to datastage....
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
options available in sequence job to run,validate?
What are the job parameters?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are the processing stages?
Why do you need stage variables?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are the differences between datastage and informatica?
What is ibm datastage?
Describe stream connector?