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


Please Help Members By Posting Answers For Below Questions

What is datastage engine?

730


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1133


What are routines in datastage? Enlist various types of routines.

627


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

657


What is a datastage job?

616






What are the benefits of datastage?

721


Define meta stage?

780


Does datastage support slowly changing dimensions ?

659


Define data aggregation?

664


What are the functionalities of link partitioner and link collector?

594


What is difference between symmetric multiprocessing and massive parallel processing?

649


What is merge stage?

760


Explain how a source file is populated?

759


Different ways a project can be moved to production ?...example ….export-import and Version control.

1931


What is the project in datastage?

665