I have a table (under db2/400) containing monthly records (2.5 Millions rows for a month) and I need them to get into another table from another library (schema) under db2/400.
It's a simple job :
tAS400Input =====>tMap ======> tAS400Output
It takes around 25 mins to run (huge considering I have 10 years history), I have tried many things such as using data storage on disk.
How can I improve the performance ?
Could you please allocate more memory to your job and check whether its improving performance?
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
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
Find out how to migrate from one database to another using the Dynamic schema