Before we load data into database, we can use tmap => dboutput
in the tMap we have store on disk option, and we can choose partitions , we need to configure one folder in the server, than load into Database
This also solves the memory issues in the job and improves performance
welcome to the community! it is great when people shared their experience!
but better to do this in the form which not ambiguous (same as at least 2 other from you)
any beginner users will start a search from here and it will be good to have really best practice only.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
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