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
- 11205 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
Explain dynamic target flat file name generation in informatica
How does a sorter cache works?
what are 3 tech challenges/ common issues you face?
What is a predefined event?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Where can we find the throughput option in informatica?
What are the components of the workflow manager?
What is sq transformation?
What is a router transformation?
how to create user defined function (udf) in informatica
What is meant by LDAP users?
What is the different lookup cache(s)?
During the running session, output files are created by informatica server. Enlist few of them.
How to do the error handling of if ur source is flatfiles?
How are the sources and targets definitions imported in informatica designer?
