Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 14221 Views
- SLK Software, I also Faced
- E-Mail Answers
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
How do you remove duplicate values in datastage?
What all the types of jobs you developed?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Can you explain players in datastage?
What are the different types of lookups in datastage?
What are system variables and sequencers in datastage
Why do we use link partitioner and link collector in datastage?
Differentiate between Join, Merge and Lookup stage?
how do u catch bad rows from OCI stage? And what CLI stands for?
Differentiate between datastage and informatica?
What are some different alternative commands associated with "dsjob"?
Nls stands for what in datastage?
Differentiate between validated and Compiled in the Datastage?
What are iconv and oconv?
How and where you used hash file?
