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
What is the reusable transformation?
Partition, what happens if the specified key range is shorter and longer
Define update strategy?
complex mapping ur project u r invlve can u explain and give real time example give me ?
State the differences between sql override and lookup override?
Enlist few areas or real-time situations where informatica is required.
Briefly define a session task?
What are the restrictions of union transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is informatica? Why do we need it?
What is a grid in Informatica?
How can you validate all mappings in the repository simultaneously?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are the different types of olap? Give an example?
How many ways are there to create ports?