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
- 10961 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
Difference between Target-based loading and constraint-based loading?
What is informatica worklet?
What is Data Caches size?
what is informatica metadata?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is xml source qualifier transformation in informatica?
How to generate sequence numbers using expression transformation?
what is song in infrmatica...?
Write the unconnected lookup syntax?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is workflow? What are the components of the workflow manager?
What is a router transformation?
What is meant by active and passive transformation?
