I have a file it contain 2 records like empname,company as
Ram, Tcs and Ram, IBM. But i want empname,
company1,company2 as Ram, TCS,IBM in the target. How?
Answer Posted / murali
Take the seq file stage and transformer and data set. in
transformer stage take two stage variables st1,st2 set the
intial value as '0' and data type is 'varchar' for st1
in st2 by using concatenate st1:',':st2
| Is This Answer Correct ? | 0 Yes | 12 No |
Post New Answer View All Answers
What are the job parameters?
Define oconv () and iconv () functions in datastage?
What could be a data source system?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is the use of hoursfromtime() function in transformer stage in datastage?
Define data aggregation?
describe the Steps to confiure a Qlogic switch
explain about citrix scheduling tool in datastage
I have a few records just I want to store data in to targets cycling way how?
root tree will find which is server job and which is parallel job?
Define Routines and their types?
what is repositery?
What is datastage?
What are the different types of lookups in datastage?
What are transforms and what is the differenece between routines and transforms?