Performance wise best approach to perform aggregrator is on DBinput vs Aggrgrator component?

[Anonymous]

Hi Team,

We need to perform aggregation in 3-4 columns in a postgres table and based on grouping output then, loading it to different table in PostgreSQL.

Please suggest the best approach on performance wise.

1. Apply query in DBinput itself -> load to table.

2. Only fetch data from table -> use talend component to performance aggregation and  load.

We are using Talend open source.

[fdenis]

bd server are made for that.
it's the quickest way.

ETL is need when you do no have link between data or when your db server are full used.