Bulk Loading Data (from www.vikramtakkar.com)
This tutorial compares a standard database data load, using a tMySQL output component, with a bulk data load component. Similar components exist within Talend Open Studio for other RDBMSs. When you have a large amount of data to load, the bulk load components offer a huge time saving – often 5 or more times quicker – which can make a big difference to your batch schedule and particularly useful if, for example, you are running an overnight batch processing regime and have to have data ready for a specific time the following day. The video describes how and when to use the bulk load components, with some cautionary notes about schema compliance. The video is from www.vikramtakkar.com. Do take a look at this site as it contains other useful Talend Open Studio tutorials.