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
- 10963 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 are the different types of transformation available in informatica.
Why filter transformation is an active one?
What is the different lookup cache(s)?
Explain the shared cache and re-cache?
what is size of u r database?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
In informatics server which files are created during the session rums?
State the limitations where we cannot use joiner in the mapping pipeline?
generate date / time dimension in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How big was your fact table
Design time, run time. If you don't create parameter what will happen
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is meant by LDAP users?
