Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.