Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are the job parameters?

1272


Define oconv () and iconv () functions in datastage?

1471


What could be a data source system?

1098


What are the enhancements made in datastage 7.5 compare with 7.0?

1215


What is the use of hoursfromtime() function in transformer stage in datastage?

1119


Define data aggregation?

1150


describe the Steps to confiure a Qlogic switch

2440


explain about citrix scheduling tool in datastage

2512


I have a few records just I want to store data in to targets cycling way how?

2418


root tree will find which is server job and which is parallel job?

2043


Define Routines and their types?

1265


what is repositery?

1930


What is datastage?

1133


What are the different types of lookups in datastage?

1112


What are transforms and what is the differenece between routines and transforms?

1110