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
What is meta stage?
Name the different sorting methods in datastage.
What are the steps needed to create a simple basic datastage job?
To see hidden files in LINIX?
Explain ibm infosphere information server and highlight its main features?
How to manage date conversion in Datastage?
What is ds designer?
What are the different type of jobs in datastage?
How one source columns or rows to be loaded in to two different tables?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
whom do you report?
explain about citrix scheduling tool in datastage
Whats difference betweeen operational data stage (ods) and data warehouse?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how