I am having Excel file with 3 sheets in it with same schema i want to pull other two sheets data in first sheet and load into mysql db ... the data load is 1 gb. also please suggest me which components to use to load into mysql...? can we use bulkload?
Bulkload will be a good idea in this case to move data to database. To read data from multiple sheets of same schema, you need to add the sheet names of all 3 tabs in the input component.
Also increase the value of custom flush buffer size in Advanced settings of in tDBOutputBulkExec so that less number of commits will happen at DB level.
Please mark as acceptable solution if the reply has solved your query. It will enrich our Talend community.