What happens when we have a port that is a plain pass through, in an aggregator transformation(i.e with out any aggregate function). Please note that, we do have group by ports in the transformation.
I.e in SQL, it is like having a field say 'A' in the select clause with out an aggregate function, but also not added in a group by clause. but there are few field added as a part of Group by. The SQL statement would return an error when trying to execute.
How does the record behave in Informatica in such a case?
Aggregator will pass the value for the last record in the group if you do not use any aggregate function on the column