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.
Tag as "solved" for others! Kudos to thanks!
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Read about some useful Context Variable ideas