Sorry, but to me your question is not clear, probably I'm still thinking too much like a software developer. :-)
Could you please provide an example what exactly you want to achieve?
The above aggregator transformation is the part of the mapping i am running, currently the target is getting populated with just the last row for each unique value of the group by port (Concat_port_final) of this table; i don't want just the last row but all all the records (unique as well as duplicate) for the group by port in the target.
Thanks and Regards
That's simply not how the Aggregator works. The AGG is defined to produce exactly one output record per group of input records. No more, no less.
If you want to have all records per group together with some aggregated value, you might want to take a look at use case #1 in the following Velocity article (it describes in detail how to perform a self-join with some aggregated data in a mapping instead of via programming or SQL code):
I thought so right from the very start, however wanted to confirm here since I couldn't find any clarification about this on the internet. Thanks a lot for replying , i really appreciate it.