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

list out all the transformations which use cache?

1190


Different qualification between a related rotate toward the sky and isolates look upward?

992


In informatics server which files are created during the session rums?

1120


What is Index Caches size?

1120


Enlist the advantages of informatica.

1070


Differentiate between router and filter transformation?

1017


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10179


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2040


Describe data concatenation?

1088


What is rank transform?

1002


Plz can any one say me how to get the informatica certification materials and dumps

2051


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8227


Where are the source flat files kept before running the session?

1087


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1130


Differentiate between joiner and lookup transformation?

1104