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 ? | 14 Yes | 1 No |
Post New Answer View All Answers
Could anyone give brief explanation bout datastage admin
Describe link sort?
State the difference between an operational datastage and a data warehouse?
how to add a new records into source?
Can you explain how could anyone drop the index before loading the data in target in datastage?
how to sort two columns in single job in datastage.
How complex jobs are implemented in datstage to improve performance?
Difference between sequential file and data set?
How do you import and export data into datastage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
On which Dimension Table you implemented SCD Type in your Project
What are the steps needed to create a simple basic datastage job?
options available in sequence job to run,validate?
How many types of views are there in a datastage director?
Define oconv () and iconv () functions in datastage?