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
- 10954 Views
- I also Faced
- E-Mail Answers
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
define galaxy repository in informatica
If informatica has its scheduler why using third party scheduler?
Different sorts of metadata that stores in the storage facility?
What do you mean by filter transformation?
How we can create indexes after completing the load process?
Why sorter is an active transformation?
What is Index Caches size?
Write the advantages of partitioning a session?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What differs when we choose the sorted input for aggregator transformation?
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)
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is the use of source qualifier?
What is data transformation manager process?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
