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
- 11210 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
Enterprise data warehouse your projects phase by phase explain?
What is meant by LDAP users?
wf dont have integration severances how you can run?
Describe the impact of several join conditions and join order in a joiner transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How is union transformation utilized?
What is the scenario which compels informatica server to reject files?
if we have a delimiters at unwanted places in a flat file how can we over come those.
where to store informatica rejected data? How to extract the informatica rejected data?
How can we update a record in the target table without using update strategy?
What is dimensional table?
State the differences between sql override and lookup override?
What are the new features of informatica 9.x developer?
What is sorter transformation?
