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 / 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 basic requirements to join two sources in a source qualifier transformation using default join?
can anyone explain me about retail domain project in informatica?
What does command task mean?
tell me the rules and responsblites in our project(my project is development)
Can we create a Integration service without a Repository service and vice versa?
what is the difference between informatica6.1 and infomatica7.1
What is the difference between source qualifier transformations source filter to filter transformation?
Please let me know how to make Data masking in informatica..
design of staging area?
During the running session, output files are created by informatica server. Enlist few of them.
What do mean by local and global repository?
What is informatica worklet?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
write a query to retrieve the latest records from the table sorted by version(scd)