Is there any performance improvement if I use individual matillion components to perform aggregations and joins rather than using the matillion query component to write the complex queries?

Matillion ETL
1

Is there any performance improvement if I use individual matillion components to perform aggregations and joins rather than using the matillion query component to write the complex queries ?

2

We can only reduce the matillion query constructing time from individual components. I don't think that will help much performance improvement.