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
- 10826 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
State the differences between sql override and lookup override?
Global and Local shortcuts. Advantages.
What is a shortcut and copy in Informatica and how two are different with each other?
Performance tuning in UNIX for informatica mappings?
How many numbers of sessions can one group in batches?
What is the difference between source qualifier transformations source filter to filter transformation?
can we override a native sql query within informatica? How do we do it?
What does command task mean?
Explain the types of transformations?
Why sorter is an active transformation?
What is an aggregator transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How can we delete duplicate rows from flat files?
What are the settings that you use to configure the joiner transformation?
Difference between Data and Index Caches?
