When using the Table Loader transformation to load an existing target table that contains one...

Indexes are removed when the Table Loader executes and must be re-created using the Table Structure

transformation.

Indexes are automatically preserved when the Table Loader executes.

Indexes are removed at the beginning of the load process and must be re-created in a subsequent job step.

Indexes can be removed or preserved at the beginning of the process depending on options chosen. Additional

table loader options specify whether to re-create the index at the end of the process.