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 is datastage engine?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are routines in datastage? Enlist various types of routines.
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
What is a datastage job?
What are the benefits of datastage?
Define meta stage?
Does datastage support slowly changing dimensions ?
Define data aggregation?
What are the functionalities of link partitioner and link collector?
What is difference between symmetric multiprocessing and massive parallel processing?
What is merge stage?
Explain how a source file is populated?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is the project in datastage?