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 / naresh
Hi All plz saw the blow
first we read the data in seqential file
then taken transformer stage in tr stage we are create the two stage variable first stage variable like
column2 : colum1
then stage variable like
str(left(stage1,1),Right(stage1,1))
out put dragan drop the stage variable
finally load the data in target.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Can you filter data in hashed file?
How do u convert the columns to rows in datastage?
What are data elements?
What are the components of datastage?
Why do we use exception activity in Datastage?
Can you implement SCD2 using join, transformer and funnel stage?
What is the differentiate between data file and descriptor file?
What are the repository tables in datastage?
What is a merge in datastage?
Can you explain engine tier in information server?
What are the important features of datastage?
What is datastage?
What are the types of containers and how to create them?
In Datastage, how you can fix the truncated data error?