I'm designing a Talend job that uses dynamic SQL to generate an output. The trouble I've found that a static defined schema is much faster than the dynamic schema. Is there some configuration that needs to be adjusted in the job to increase throughput? The below is the same query using a dynamic schema and static schema. The static schema can actually go faster than shown but the dynamic maxes out at 5-7 rows a second.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables