Can anyone help me on how to use aggregate function for the output of tELTOracleMap?
Because taggregate row is not compatible for tELTOracleMap component
A ELT component does not have a physical output in the job it self because everything is done in the database by SQL statements. Therefore you will hardly find a component to aggregate the data within the job. Aggregating in the database could mean reading it with a appropriated statement containing a group by clause. This can be done with the normal tOracleInput component.