The Table Loader transformation incorrectly deletes the index on the key column when the following conditions are true:

1. Load Style is set to Update/Insert on the Load Technique tab in Table Loader properties.
2. Matching Rows is set to either Modify by Column(s) or Modify using Index in the Technique(s) section on the Load Technique tab in Table Loader properties.
3. Before Load is set to Off in the Index Condition section on the Load Technique tab in Table Loader properties.
4. An index exists on the key column used for matching the source table with the target table.

The impact of deletion of the key column index is as follows.

When Matching Rows is set to Modify by Column(s), the update process completes without errors. However, performance can be significantly impacted. The missing index results in the process performing a sequential read instead of an indexed read of the target table.

When Matching Rows is set to Modify using Index, the following error will occur due to the missing index:

Operating System and Release Information