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 / shirish
In expression transformation use an output port ...in
expression window write emp_id||empname
| Is This Answer Correct ? | 7 Yes | 15 No |
Post New Answer View All Answers
What is meant by query override?
What is session task and command task?
Under which circumstances, informatica server creates reject files?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Explain the mapping variable usage example in informatica
What is informatica? Why do we need it?
Differentiate between Load Manager and DTM?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the restrictions of union transformation?
What is a transaction control transformation?
How to do unit testing in informatica? How to load data in informatica ?
What are the settings that you use to configure the joiner transformation?
What is workflow? What are the components of workflow manager?
What is the need of an ETL tool?
What are multi-group transformations?