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 flat file, in which i have two fields, emp_id,
emp_name. The data is like this,
emp_id,emp_name
101,soha
101,ali
101,khan
102,siva
102,shanker
102,reddy.
how to merge the names so that my output is like this
Emp_id Emp_name
101 Soha ali kahn
102 siva shenkar reddy

please provide solution

Answer Posted / gd

Use aggregator t/r In that condition group by on emp_id and
create output port with expression concat('emp_id','
','emp_name');

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1108


can anyone explain me about retail domain project in informatica?

7931


What does command task mean?

1124


tell me the rules and responsblites in our project(my project is development)

1920


Can we create a Integration service without a Repository service and vice versa?

1206


what is the difference between informatica6.1 and infomatica7.1

2256


What is the difference between source qualifier transformations source filter to filter transformation?

1033


Please let me know how to make Data masking in informatica..

1701


design of staging area?

2020


During the running session, output files are created by informatica server. Enlist few of them.

970


What do mean by local and global repository?

1204


What is informatica worklet?

1042


Explain where to store informatica rejected data? How to extract the informatica rejected data?

996


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2011


write a query to retrieve the latest records from the table sorted by version(scd)

1053