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
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Define Data Stage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how do u catch bad rows from OCI stage? And what CLI stands for?
what are the errors,warnings in datastage
project Steps,hits, Project level HArd things,Solved methods?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is difference between server jobs & parallel jobs?
Define meta stage?
Define repository tables in datastage?
What is the sortmerge collector?
What is a merge in datastage?
What are the main features of datastage?
How to reverse the string using SQL?
Describe routines in datastage? Enlist various types of routines.