Interested to Buy Any Domain ? << Click Here >> for more details...
source : col1 101 101 101 102 102 102 103 103 103
col2 1000 1500 2000 1200 2300 3000 2400 1300 2000
i need target as
col1 101 102 103
col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
- 6 Answers
- 11062 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / john coder
i believe, we need an aggregator to pick up the last row for
a particular deptno.
Otherwise, there will be three rows inserted...
col1 col2
101 1000
101 1000,1500
101 1000,1500,2000
by having an aggregator with groupby on col1, we can pick up
the last row by either using LAST or MAX.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Write the different tools in the workflow manager?
Mention a few design and development best practices for informatica?
What is standalone command task?
difference between repository database and repository service?
In how many ways we can create ports?
Reusable transformation and shortcut differences
What is a shortcut and copy in Informatica and how two are different with each other?
What is a filter transformation?
What is an unconnected transformation?
Explain what is informatica metadata and where is it stored?
Explain the difference between a data warehouse and a data mart?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Explain sessions. Explain how batches are used to combine executions?
what is the Default Source Option For Update Strategy Transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
