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

Six Stars

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

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.

 

 

Twelve Stars

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

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.

Francois Denis

Tag as "solved" for others! Kudos to thanks!

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog