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 / 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
Different circumstance which drives informatica server to expel records?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the new features of Power Center 5.0?
Write the prerequisite tasks to achieve the session partition?
What is a filter transformation?
Explain what is informatica metadata and where is it stored?
How can we handle two sessions in informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Define filter transformation?
Explain what are the different types of transformation available in informatica.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
can anyone explain me about retail domain project in informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions