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
list out all the transformations which use cache?
Different qualification between a related rotate toward the sky and isolates look upward?
In informatics server which files are created during the session rums?
What is Index Caches size?
Enlist the advantages of informatica.
Differentiate between router and filter transformation?
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?
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
Describe data concatenation?
What is rank transform?
Plz can any one say me how to get the informatica certification materials and dumps
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Where are the source flat files kept before running the session?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Differentiate between joiner and lookup transformation?