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
- 5 Answers
- 11396 Views
- I also Faced
- E-Mail Answers
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
What is target designer and target load order?
Explain the different kinds of facts.
What do you understand by a term domain?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How are the sources and targets definitions imported in informatica designer?
Enlist some properties of sessions.
What are junk dimensions?
As union transformation gives UNION ALL output, how you will get the UNION output?
How to load a Dimension ? and how to load a fact table?
How does the aggregator transformation handle null values?
How might one distinguish in the case of mapping is right or not without associating session?
Enterprise data warehouse your projects phase by phase explain?
How can we update a record in the target table without using update strategy?
Define update strategy?
What are active transformations.
