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
- 11386 Views
- I also Faced
- E-Mail Answers
Answer Posted / dharmendra
SOURCE->SRT->EXP->AGT->TGT
SRT - Sort by column col1.
EXP - empid
name
v_name=iif(v_empid=empid,v_name||','||name,name)
v_empid=empid
o_empid=v_empid
o_name=v_name
After this we can use aggregator t/r to take last row for a
particualr emp id using LAST.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explian the Process of deployment groups in informatica
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is Data Caches size?
expain about the tune parameters?
Explain lookup transformation in informatica
What is the need of etl tools?
What do you understand by a term domain?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is data movement mode in Informatica and difference between them?
Write the different tools in the workflow manager?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
