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 / satish
Hi
First read the data in sequential file,
then take transformer stage create a stage variable.
In stage variable
Str( DSLink2.column_2, DSLink2.Column_1).
Drag and drop the stage variable to required output column,
finally load the data in target.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Differentiate between validated and Compiled in the Datastage?
What are orabulk and bcp stages?
To see hidden files in LINIX?
What is active and passive stage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What are the various kinds of containers available in datastage?
Explain ibm infosphere information server and highlight its main features?
what is the use of materialized view?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are routines in datastage? Enlist various types of routines.
Can you explain link buffering?
Name the third party tools that can be used in datastage?