How to drop index before job and regenerate them after

One Star

How to drop index before job and regenerate them after

Hi everyone,
I'd lke to know if there was an easy way in talend to drop indexes on tables (I use mysql) in talend 2.0.2 java first in a job and then at the end to generate them again. It's obvious that for big jobs includind LOTS and LOTS of inserts/update, there is a performance boost at doing this, but I see no easy way of doing it!
Thx for your help!
One Star

Re: How to drop index before job and regenerate them after

Hi,
1. Drop indexes with a tMysqlRow component linked to the tMysqlInput with the Trigger
2. Create indexes with a tMysqlRow component after the insert with the Trigger
tMysqlRow --> --> tMysqlInput --> --> tMysqlOutput --> --> tMysqlRow
Hope this help.
One Star

Re: How to drop index before job and regenerate them after

Hi,
I need to drop index and truncate table before inserting into table. Can any one please explain how to do this kind of jobs
My jobs is tOrcleInput-->tmap-->tOracleOutput
how to change my job to drop index
Five Stars

Re: How to drop index before job and regenerate them after

Take a look at "Action on table" of tOracleOutput. If one of these does not work for you, then it is the same answer as previously posted for MySQL.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now