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
- 11225 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
Can you generate sequence numbers without using the sequence generator transformation?
On which transformations you created partitions in your project?
Clarify the utilization of aggregator cache record?
What is persistent lookup cache?
Suppose we do not group by on any ports of the aggregator what will be the output?
How to improve the performance of a session using sorter transformation?
Define mapplet?
what is $$$$?
What is a transaction control transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain target update override in informatica
How can we handle two sessions in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are mapplets? How is it different from a Reusable Transformation?
What are the prerequisite tasks to achieve the session partition?
