Multiple choice technology

In bulk mode of loading we cannot use indexes

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Bulk loading mode in Informatica (and most ETL tools) bypasses index maintenance during the load operation for maximum performance. Indexes are typically dropped or disabled before bulk load and rebuilt afterward. Using indexes during bulk load would defeat its performance purpose.