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 are datastage sequences?
Explain the situation where you have applied SCD in your project?
What are the different kinds of views available in a datastage director?
How you Implemented SCD Type 1 & Type 2 in your project?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Where do the datastage jobs get stored?
Lookup constraints
How to read multiple files using a single datastage job if files have the same metadata?
What is the difference between orabulk and bcp stages?
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?
Differentiate between hash file and sequential file?
What is process model?
what is use of SDR function?
What is the different type of jobs in datastage?