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 / geetha
use str function in datastage. str(dslink.column1,dslinkcolumkn2). In the output we get the required data . str function is used to repeat the column number of times.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are transforms and what is the differenece between routines and transforms?
what is the use of materialized view?
How many Key we can define in remove duplicate stage?
Does datastage support slowly changing dimensions ?
What are the job parameters?
What are the enhancements made in datastage 7.5 compare with 7.0?
Differentiate between data file and descriptor file?
how to export or import the jobs in .ISX file
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are the different plug-ins stages used in your projects?
Define oconv () and iconv () functions in datastage?
What are the difference types of stages?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the roundrobin collector?